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.
ERBuilder is a GUI data modeling tool that allows you to visualize, design and model databases by using entity relationship diagrams and automatically generates the most popular SQL databases. Reverse engineer, generate and share the data Model documentation with your team. Optimize your data model by using advanced features such as test data generation, schema compare and schema synchronization. Try now ERBuilder for 15 days FREE
Subscribe to our email newsletter today to receive updates of the latest news, tutorials and special offers!