I'm often looking for some precise informations in Alfresco database. This is quite hard when you don't have a graph showing the database schema.

I have recently discovered that SQuirreL SQL could help me in this task. Select each table to show in the graph, right-clic and select Add to graph. There is now only to reorganize the graph manually to make it readable. The graph can be renamed and saved with the contextual menu of the graph.

Here is a picture showing Alfresco database schema created using this method.

Alfresco database schema