Is there a database diagram?

The OMERO database schema is reasonably large and complex so a diagram is not the greatest way to represent it. As it has been requested a few times we generated one for version 4.1. We would not recommend trying to work from it.

It is available here but is a very large pdf:
Database Diagram for OMERO 4.1 generated March 2010
The PDF has two layers so in an application that supports layers the lines can be turned off to see the tables easier.

If anyone can recommend a good application for generating a diagram from either a Postgres database or direct from the SQL please get in touch.