E-commerce database schema examples and ER diagrams
What an E-commerce schema usually contains
Orders are the awkward part of an e-commerce schema: a line item has to remember the price it was bought at, not the price the product carries now. These templates keep products, variants, carts and orders separate so history survives a price change.
Templates (2)
E-commerce Free
Restaurant Ordering and POS Database Schema
A 29-table restaurant ordering and POS database schema covering the floor plan, menu, checks, kitchen tickets, voids and comps, payments, cash drawers and day close: free ER diagram and DBML.
- tables
- 29
- columns
- 220
- refs
- 60
E-commerce Free
E-commerce Database Schema
A complete 36-table e-commerce database schema with products, variants, cart, orders, inventory, payments and returns — free ER diagram and DBML.
- tables
- 36
- columns
- 236
- refs
- 46