Alfresco is an open-source Enterprise Content Management (ECM) system developed using Java. It is one of the most well-designed ECM systems from the point of view of its architecture, performance and Web interface. The first version of Alfresco was released in 2005. Alfresco provides multiple features as a content repository, full-text indexer, Workflow Engine, LDAP, SMTP server (Messaging), mobile access, etc. Alfresco's services are based on a content repository consisting of:
1. Content metadata that is stored in a relational database such as MySQL, PostgreSQL, Oracle Database, IBM DB2, Microsoft SQL Server, MariaDB, Amazon Relational Database Service and Amazon Aurora
2. Actual content that is stored in a file system.
The complete Alfresco database documentation, with descriptions of tables and columns, is available here. This documentation is generated by our modeling tool, ERBuilder. The diagram below is the result of reverse engineering the Alfresco database with the ERBuilder data modeler.