topic Re: Alfresco Database Schema Diagram - ERD in Alfresco Forum

Alfresco Database Schema Diagram - ERD

mani_zaeim — Mon, 23 Apr 2018 05:40:08 GMT

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 t

Re: Alfresco Database Schema Diagram - ERD

afaust — Mon, 23 Apr 2018 07:20:05 GMT

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...