Alfresco Database Schema

[borledge]

Is there a ERD diagram to describe the Alfresco database schema?  I'd like to get this information to understand the inner-workings of Alfresco and without this it is very difficult.

THanks.

[borledge]

Wow! I can't believe that this is a difficult question. Is it so strange to request the underlying schema structure (or ER diagram)?

Please help.

[mark_smithson]

Alfresco uses hibernate which is an ORM layer.

I would guess that the design is more focussed on a data object model, rather than a schema for the database.

The object model can be gleaned from the JavaDocs, but it would be good to have an overview UML diagram. Does anyone know if one exists on the wiki?

[vycitalr]

I found the diagram describing DB model (part of) here http://wiki.alfresco.com/w/images/7/71/Alfresco-Core-DB-Tables.jpg

[boscoferrao]

I need the ERD for Alfreco AVM. Please can anyone help?

[n_pancholi87]

Hey, I have a query regarding schemas.
Can Alfresco communicate with 2 schemas simultaneously?
Like for instance I have a custom schema that contains some selected important tables that I want to store and an Alfresco Schema that is there by default. Can Alfresco read and update both the schemas in one go?

Or otherwise is it possible to change the default location where alfresco stores all the data (in the filesystem) to database of choice?

[raghavendra_pra]

Hi there,
For data model analysis, if you are using MySQL, use MySQL work bench to reverse engineer the tables and you get ERD.

Regarding a separate schema for your customization (I understood this way). I would rather suggest you develop another .war with another schema and expose as web services.
Downside of having your custom tables in the same schema is to manage your upgrades as Alfresco new releases come…

rgds/RP.

[n_pancholi87]

hey thnx!

[brianh]

Hi there,
For data model analysis, if you are using MySQL, use MySQL work bench to reverse engineer the tables and you get ERD.

Regarding a separate schema for your customization (I understood this way). I would rather suggest you develop another .war with another schema and expose as web services.
Downside of having your custom tables in the same schema is to manage your upgrades as Alfresco new releases come…

rgds/RP.

Yes.

I've also received this task this morning, and have had the same idea too.  There is a drawback however.  Reversing from low level up will be minimal on the 'business descriptions' for each entity and field, and so will not really produce the ERD / UML style presentation which I'm being asked to provide.

I'm still searching if something is available directly by Alfresco on this.

[mrogers]

No we don't publish the database scema since a) its considered private implementation details b) it changes frequently.

We recommend that users should use one of the public APIs and not access the database directly.

That said the schema is fairly simple.