Inventory / warehouse Schema

Interactive diagram

Drag to pan, scroll to zoom. Open it in the full editor to edit, rearrange and export.

About this schema

Suppliers provide products; stock tracks quantity of each product per warehouse; purchase orders to suppliers contain line items for products.

Schema (SQL)

CREATE TABLE suppliers (
  id SERIAL PRIMARY KEY,
  name VARCHAR(160) NOT NULL,
  email VARCHAR(255)
);
CREATE TABLE products (
  id SERIAL PRIMARY KEY,
  supplier_id INT REFERENCES suppliers(id),
  sku VARCHAR(64) UNIQUE, name VARCHAR(200),
  unit_cost_cents INT
);
CREATE TABLE warehouses (
  id SERIAL PRIMARY KEY,
  code VARCHAR(10) UNIQUE, name VARCHAR(120),
  location VARCHAR(160)
);
CREATE TABLE stock (
  id SERIAL PRIMARY KEY,
  product_id INT NOT NULL REFERENCES products(id),
  warehouse_id INT NOT NULL REFERENCES warehouses(id),
  quantity INT
);
CREATE TABLE purchase_orders (
  id SERIAL PRIMARY KEY,
  supplier_id INT NOT NULL REFERENCES suppliers(id),
  warehouse_id INT REFERENCES warehouses(id),
  status VARCHAR(20), ordered_at TIMESTAMP
);
CREATE TABLE purchase_order_items (
  id SERIAL PRIMARY KEY,
  purchase_order_id INT NOT NULL REFERENCES purchase_orders(id),
  product_id INT NOT NULL REFERENCES products(id),
  quantity INT, unit_cost_cents INT
);

Open in the editor → to export it as PNG, SVG, Mermaid or DBML.

More examples