Entity Relationship Diagram

What is an entity relationship (ER) diagram? An ER diagram is a visualization of tables within a database and how they relate to each other. This topic contains a few ER diagrams to help you visualize the relationship between a few common Adobe Commerce database tables.

Core Commerce ER Diagram

This ER diagram represents the relationships among the core tables within a Commerce database. By viewing multiple relationships at once, you can see how data would relate across many tables.

The sections below contain ER diagrams specific to two tables at a time. To view a diagram and its accompanying description, click on the header for that section.

customer\_entity & sales\_flat\_order

One customer can place many orders. The relationship between these two tables is customer\_entity.entity\_id = sales\_flat\_order.customer\_id

Within Commerce Intelligence, if the path between these two tables does not exist, you can create the path within the Data Warehouse tab. When you are ready to create the path, it is defined as follows:

sales\_flat\_order & sales\_flat\_order\_item

One order can contain many items. The relationship between these two tables is sales\_flat\_order.entity\_id = sales\_flat\_order\_item.order\_id.

Within Commerce Intelligence, if the path between these two tables does not exist, you can create the path in the Data Warehouse tab. When you are ready to create the path, define the path as demonstrated below.

catalog\_product\_entity & sales\_flat\_order\_item

One product can be purchased many items. The relationship between these two tables is catalog\_product\_entity.entity\_id = sales\_flat\_order\_item.product.

Within Commerce Intelligence, if the path between these two tables does not exist, you can create the path within the Data Warehouse tab. When you are ready to create the path, define the path as demonstrated below.