ER diagram
Ecommerce database
Customers, orders, order lines, products and inventory.
- Category
- Technical
- Diagram type
- ER diagram
- Elements
- 5
- Connectors
- 4
What it is for
order_lines stores unit_price so historical orders keep the price paid rather than the current one. That single column is the difference between a working shop and a support problem.
More about the er diagram makerWhen it helps
- Designing a shop schema
- Explaining price snapshots
- Planning a stock integration
