Skip to content
flowss
Start freeChecking your session
DBML templates

Inventory Schema (DBML)

Warehouses, products, suppliers and stock.

DBMLData & SchemaDBML syntax docs
Template previewDBML
products.supplier_id > suppliers.idstock.warehouse_id > warehouses.idstock.product_id > products.idsuppliersiduuidnamevarcharwarehousesiduuidlocationvarcharproductsiduuidskuvarcharnamevarcharsupplier_iduuidstockwarehouse_iduuidproduct_iduuidquantityint

Make it your own.

Table suppliers {
  id uuid [pk]
  name varchar
}

Table warehouses {
  id uuid [pk]
  location varchar
}

Table products {
  id uuid [pk]
  sku varchar [unique]
  name varchar
  supplier_id uuid [ref: > suppliers.id]
}

Table stock {
  warehouse_id uuid [ref: > warehouses.id]
  product_id uuid [ref: > products.id]
  quantity int
}