Skip to content
Copper Lane Payments
Read-only example
Search
⌘K
Entities
Where it lives
Tables
Logical
Physical
Design
Payment state · illustrative PostgreSQL design
Payment state · illustrative PostgreSQL design
PostgreSQL
Details
Keys
Names
Keys
All columns
100%
Model & designs
Copper Lane Payments
payment_id → payments.id
refund_id → refunds.id
order_id → orders.id
payment_id → payments.id
Table
confirmations
Processor confirmation
event_id
text
payment_id
text
refund_id
text
+1 more
Table
orders
Order reference
id
text
+2 more
Table
payments
Payment
id
text
order_id
text
+5 more
Table
refunds
Refund
id
text
payment_id
text
+4 more
Primary key
Foreign key
Unique
Click a card to see its details; drag to pan, Ctrl+scroll to zoom
Search
Esc
Map
View
Document
View
Open my projects
Page
Nothing matches.