E-commerce ER Diagram
SQL DDL Scripts
Purchase E-commerce Data Model Pack
Help Docs

Legend:  TopTop  Open specification Open Entity specification

Jump to:

Refund:Entity Sale_Return_Item:Entity Stock_Return_Item:Entity Purchase_Item:Entity Loss_And_Damage_Item:Entity Supplier_Item_Tax_Type:Entity Supplier_Tax_Type:Entity Loss_And_Damage:Entity Admin_User:Entity Sale_Return:Entity Loyalty_Card_Type:Entity Inventory_Count_Item:Entity Inventory_Count:Entity Stock_Return:Entity Purchase:Entity Document_Category:Entity Order_Discount:Entity Order_Line_Discount:Entity Document_Type:Entity Document:Entity Stock_History:Entity Item_Tax_Type:Entity Unit_Of_Measure:Entity Bar_Code:Entity Loyalty_Card:Entity Supplier:Entity Tax_Type:Entity Discount_Hour:Entity Week_Day:Entity Invoice_Line:Entity Order_Line:Entity Discount:Entity Discount_Type:Entity Price:Entity Item:Entity Item_Category:Entity Shipment:Entity Payment_Time:Entity Invoice:Entity Payment:Entity Payment_Term:Entity Payment_Method:Entity Delivery_Type:Entity Sales_Channel:Entity Order_Status_History:Entity Order_Status:Entity Order_Header:Entity Customer:Entity Employee_Login:Entity Role_Function:Entity Function_Type:Entity Employee_Role:Entity Role_Type:Entity Media:Entity Media_Type:Entity Order_Review:Entity Employee:Entity Hour:Entity Setting:Entity Currency:Entity Language:Entity Holiday:Entity Holiday_Reason:Entity Store:Entity Time_Zone:Entity City:Entity Region:Entity Country:Entity

Open in browser →

Help Docs →

SQL DDL Scripts →

All data models →

E-commerce Data Model →

E-commerce database schema design

Entities and Attributes

Navigate to each subject area of the E-commerce database diagram to get powerful insights into entities and attributes — tables and columns.

Subject Areas Entities
CUSTOMER → 7 entities
STORE → 10 entities
ITEM → 8 entities
INVENTORY AND STOCK → 4 entities
PRICE AND DISCOUNT → 5 entities
ORDER → 13 entities
DOCUMENT → 16 entities
PAYMENT AND INVOICE → 4 entities
EMPLOYEE AND ROLE → 7 entities

E-commerce database Help Docs

Understand your database schema and learn how the use cases are mapped to database tables and columns.

From our detailed documentation, you can learn about the features and technical design of E-commerce database schema.

Read the Help Docs →

ER Diagram for E-commerce | E-commerce Entity Relationship Diagram | E-commerce ER Diagram | E-commerce database schema diagram | E-commerce database diagram

Purchase the full version of the SQL scripts to create 100% of the database schema and benefit from priority customer support →

Accelerate every database schema design with powerful data models

We have already designed the data model and prepared the SQL scripts for creating the database schema objects.

Try Data Model Pack Free

Data Model Pack

Product

Resources

Support

© 2026 Data Model Pack · Terms of Use · Privacy

Back to top Top