Hi All,
I already view all the topics related to this question but i can not find any suitable answer for that. I will be appreciated if anyone can provide the #ERD by the reverse engineering the default existing tables of the alfresco installation. It would be really importamt for technical users to see high level overview of the #architecture #diagrams and #Database #schema #diagrams as well as #objectRelation and #classDiagrams. Unfortinately alfresco community seems did not provide these.
Thanks.
I did a quick search for "Alfresco ERD" in Google and the very first result was already a decent one: Alfresco Entities and Relationships [infographics]
This is for an older version of Alfresco (3.4) but the core tables (alf_node_*, alf_transaction, alf_qname, alf_child_assoc, alf_namespace...) haven't changed that much since then. Only the auxilliary ones regarding workflow, audit and attributes have changed substantially.
Since nobody should be messing with the Alfresco DB directly (changing / adding / deleting data) without going through the Alfresco APIs, there is usually little need for an extensive, up-to-date ERD. Though if you need it and end up updating what Contentreich provided to a more recent Alfresco version, it would sure be appreciated if you contribute that back so other people in your position will have it easier in the future...
Hi,
If you are able to connect to your Alfresco database, you can obtain this diagram, for example using: DBVisualizer
NeTIC360: :: Alfresco. Obtener el modelo de datos
Regards,
clv
As Axel says, you can search around. Here are some other examples:
Understanding Alfresco Content Data Model | Lionsgate Software (Jul 2017)
Entrando por la “puerta de atrás” en Alfresco – Blog de Fegor (Aug 2014 - up to 4.2.2)
As mentioned in previous comment, you can also reverse-engineer. Other tools include SchemaSpy or even MySQL Workbench (if using MySQL), eg.
Deep Dive: Alfresco Core Repository (... embedded in a micro-services…
Regards,
Jan
Hi all,
I share with you what I found about Alfresco database model (schema).
https://soft-builder.com/en/docs/Alfresco/index.html
The second link gives more details about the alfresco schema.
Regards,
Abhaya.
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.