Schematex
erd·Crow's-foot (Everest 1976) / DBML compatible·software, retail·complexity 2/3

E-commerce schema

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

For the backend engineer

Open in Playground →
erd·§ —
↘ preview
100%
E-commerce Schema Entity-Relationship Diagram with 6 entities and 5 relationships. E-commerce Schema places Customer customer_id int PK email varchar UK name varchar created_at timestamp Category category_id int PK name varchar Address address_id int PK customer_id int FK line1 varchar city varchar zip varchar Order order_id int PK customer_id int FK placed_at timestamp status varchar Product product_id int PK category_id int FK name varchar price decimal OrderLine order_id int PK FK line_no int PK product_id int FK qty int price decimal
UTF-8 · LF · 51 lines · 1274 chars✓ parsed·10.6 ms·12.4 KB SVG

A six-table schema spanning four FK-depth layers: Category and Customer at the root; Product and Address at depth one; Order at depth two; OrderLine at depth three with a composite PK (order_id, line_no). Demonstrates layered LR routing and labelled relationships ("places").

ERD syntax →