Skip to content
flowss
Start freeChecking your session
DBML templates

E-commerce Schema (DBML)

Customers, orders, products and line items.

DBMLData & SchemaDBML syntax docs
Template previewDBML
orders.customer_id > customers.idorder_items.order_id > orders.idorder_items.product_id > products.idcustomersiduuidemailvarcharnamevarcharordersiduuidcustomer_iduuidstatusvarchartotaldecimalcreated_attimestampproductsiduuidskuvarcharnamevarcharpricedecimalorder_itemsorder_iduuidproduct_iduuidqtyint

Make it your own.

Table customers {
  id uuid [pk]
  email varchar [unique, not null]
  name varchar
}

Table orders {
  id uuid [pk]
  customer_id uuid [ref: > customers.id]
  status varchar
  total decimal
  created_at timestamp
}

Table products {
  id uuid [pk]
  sku varchar [unique]
  name varchar
  price decimal
}

Table order_items {
  order_id uuid [ref: > orders.id]
  product_id uuid [ref: > products.id]
  qty int
}