Joomla! CMS – online ER diagram

By joomla.org:

  • Joomla! is a free and open-source content management system (CMS) for publishing web content.
  • Joomla! is one of the most popular website softwares, thanks to its global community of developers and volunteers, who make sure the platform is user friendly, extendable, multilingual, accessible, responsive, search engine optimized and so much more
  • Joomla! is used all over the world to power millions of websites of all shapes and sizes.

For more information visit https://www.joomla.org

HTML report / online ERD

The online entity relationship diagram (online ERD) was created by reverse engineering the database structure from locally installed Joomla! version 3.9.28. No Joomla! extensions were installed and the target database was MariaDB with InnoDB default engine.

How to use the simple ERD: click on a db table in the online ERD. A new window opens – and in the window you can view the details of the table, including how indexes are defined and other details of the selected MariaDB table.

The database structure doesn’t include relationships and like in many other open source systems, database functions, table triggers and other database objects are not specified.

Details

Target database:
MariaDB

Diagram URL:
https://www.dbdiagrams.com/online-diagrams/Joomla-3-9-28/

Moon Modeler project file:
https://www.dbdiagrams.com/online-diagrams/Joomla-3-9-28.dmm

How to:
Open *.dmm project file in Moon Modeler

About Moon Modeler: a desktop data modeling tool for MariaDB, MySQL, PostgreSQL, MongoDB, SQLite, GraphQL and Mongoose ODM. It allows you to create ER diagrams of existing databases, visualize nested structures, generate SQL or schema creation scripts and produce PDF or HTML reports. A feature-limited free version is available for Windows, macOS and Linux. For more information about Moon Modeler please visit https://www.datensen.com

Moon Modeler - er diagrams and generation of online er diagram reports.

If you have suggestions or comments, send us a message to dbdiagrams(at)dbdiagrams.com.