ERD Sample - Opencart

OpenCart – online ER diagram

ERD Sample - Opencart


  • The best FREE and open-source eCommerce platform. Everything you need to create, scale and run your business.
  • Opencart is an easy to-use, powerful, Open Source online store management program that can manage multiple online stores from a single back-end.
  • With a huge range of features included out-of- the-box and over 14,000 additional extensions available to download, OpenCart is perfect for ecommerce stores of any size, any industry, any budget.

For more information visit

HTML report / online ER diagram

The database diagram was created by reverse engineering the database structure from locally installed OpenCart version The target database type was MariaDB with InnoDB default engine.

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

The database structure is relatively simple and like in many other open source systems, database functions, table triggers and other database objects are not defined.


Target database:

Diagram URL:

Luna Modeler project file:

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

About Luna Modeler: a desktop data modeling tool for MariaDB, MySQL, PostgreSQL and SQLite. It allows you to create ER diagrams of existing databases, generate SQL or schema creation scripts and produce PDF or HTML reports. A feature-limited trial version is available for Windows, macOS and Linux. For more information about Luna Modeler please visit

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