Back to flowchart examples
Mapfable
Read-only diagram
Use this example
Dark
Overview
View
Whole diagram
Before this step
After this step
Show route
From
Choose a step
To
Choose a step
Show route
Motion
Play messages
Messages play in saved order; spacing is not measured time.
JavaScript is disabled. The complete diagram is visible below; interactive viewing requires JavaScript.
Commerce · Customer, checkout & catalogue
Commerce · Customer, checkout & catalogue
A relational design for customer accounts, checkout, products and inventory. Business domains keep related tables together; keys and endpoint symbols explain how records connect.
Database relationships · Endpoint labels show how many records may relate. Relationships are not runtime traffic.
Accounts
Checkout
Catalogue
Line items
placed by
placed by
payment for
payment for
belongs to
belongs to
references
references
stock of
stock of
Customers
Customers
PK
id
uuid
UK
email
varchar(255)
display_name
varchar(120)
created_at
timestamp
Orders
Orders
PK
id
uuid
FK
customer_id
uuid
status
order_status
total_amount
numeric(12,2)
currency
char(3)
placed_at
timestamp
Payments
Payments
PK
id
uuid
FK
order_id
uuid
method
varchar(32)
amount
numeric(12,2)
paid_at
timestamp
nullable
UK
external_ref
varchar(64)
Inventory
Inventory
PK
id
uuid
FK
product_id
uuid
warehouse_code
varchar(16)
quantity
integer
reserved_quantity
integer
updated_at
timestamp
Products
Products
PK
id
uuid
UK
sku
varchar(64)
name
varchar(160)
price
numeric(12,2)
active
boolean
created_at
timestamp
Order items
Order items
PK
id
uuid
FK
order_id
uuid
FK
product_id
uuid
quantity
integer
unit_price
numeric(12,2)
discount_amount
numeric(12,2)
PK
Primary key
FK
Foreign key
UK
Unique key
One
Many
Optional
Read-only snapshot · Sources describe their recorded context.
−
+
Fit whole diagram
Whole diagram