ChatDiagram
ER Diagram · ERD

E-commerce schema — ER Diagram

Production-style schema with Customer / Order / OrderLine / Product / Category — typical mid-complexity backend ERD with composite PK on the line-item table.

Type Entity-Relationship Diagram (ERD)Standard Chen 1976 / Everest 1976 (crow's foot)Engine schematex-erdUpdated 5/27/2026
E-commerce schema
Drawing preview
The request

“Create an e-commerce ERD with Customer, Address, Category, Product, Order, and OrderLine tables, the shown keys and attributes, customer addresses and orders, products in categories, and order lines linked to orders and products.”

Then tryAdd payments to orders.Add product reviews.
More like this

Other examples in this family.

Browse all erd templates →