Skip to content
arch-lab
View
Demo
Syntax
Validate
MCP
Beta
Editor
Shop orders
Open in the playground
places
contains
ships to
writes
Customer — Anyone who has ever placed an order
Customer
PostgreSQL
id
PK
uuid
email — Lowercased on write, so it can be a unique key
email
UK
string
name
string
created_at
timestamptz
Order
id
PK
uuid
customer_id
FK
uuid
placed_at
timestamptz
total
numeric(10,2)
Address
id
PK
uuid
customer_id
FK
uuid
line1
string
postcode
string
Order line
order_id
PK FK
uuid
sku
PK
string
quantity
integer
unit_price
numeric(10,2)
Audit log
Fit