Joomla! CMS – online ER diagram

View the diagram Open full screen
Entity relationship diagram for Joomla CMS

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

Joomla! CMS · ER diagramOpen in new tab

Details#

Target database
MariaDB
Luna Modeler project file
https://www.dbdiagrams.com/online-diagrams/joomla.dmm
Joomla! license
GPL v2 or later

Build on Joomla!#

Improve the system

Extend Joomla!

Planning a plugin, module or extension? Find the tables you will work with, then model your own tables and amendments right next to them, before you write a line of code.

Get inspired

Craft a new system

Building something of your own? Study how Joomla! structures its data, take the ideas that work, and design a data model that fits your project.

Respect the license. Joomla! is released under the GPL v2 or later. Copyleft licenses like this one generally require that work based on the code that you distribute, such as a plugin or a fork, is released under the same license and keeps the original copyright notices. Whatever you build, read the license and follow its terms.

More ER diagrams

All in MariaDB
MariaDB ER diagram GPL v2+

Drupal CMS – online ER diagram

Drupal is content management software. It’s used to make many of the websites and applications you use every day. Drupal has great standard features, like easy content authoring, reliable performance, and excellent security.

MariaDB ER diagram GPL v2+

WordPress CMS – online ER diagram

According to WordPress.com: WordPress is open source software you can use to create a beautiful website, blog, or app. See the ERD here.

MariaDB ER diagram GPL v2

osTicket – ER Diagram

by osTicket.com: osTicket is a robust customer support portal system to help your business maintain happy customer relationships.