04-22-2018 10:40 PM
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.
04-23-2018 12:20 AM
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...
04-23-2018 03:56 AM
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
06-08-2018 06:11 AM
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
03-12-2019 05:57 AM
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.
Explore our Alfresco products with the links below. Use labels to filter content by product module.