logo
ExamplesEditorPricingDocs
37.1kSign in

Warehouse & inventory management database schema

Bin-level inventory done properly: warehouses and storage locations, lot tracking for recalls, an append-only stock movement log with derived stock levels, purchase orders and outbound shipments.

Warehouse Inventory ER diagram

Warehouse & inventory management database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 suppliers idBIGINT codeVARCHAR nameVARCHAR contact_emailVARCHAR lead_time_daysINTEGER is_activeBOOLEAN warehouses idBIGINT codeVARCHAR nameVARCHAR address_line1VARCHAR cityVARCHAR country_codeCHAR timezoneVARCHAR is_activeBOOLEAN storage_locations idBIGINT warehouse_idBIGINT codeVARCHAR location_typeVARCHAR zoneVARCHAR capacity_unitsINTEGER is_pickableBOOLEAN items idBIGINT skuVARCHAR nameVARCHAR barcodeVARCHAR unit_of_measureVARCHAR weight_gramsINTEGER is_lot_trackedBOOLEAN is_activeBOOLEAN lots idBIGINT item_idBIGINT lot_codeVARCHAR expires_onDATE received_onDATE supplier_idBIGINT stock_levels idBIGINT warehouse_idBIGINT location_idBIGINT item_idBIGINT lot_idBIGINT quantity_on_handINTEGER quantity_allocatedINTEGER last_counted_atTIMESTAMP updated_atTIMESTAMP stock_movements idBIGINT warehouse_idBIGINT item_idBIGINT lot_idBIGINT from_location_idBIGINT to_location_idBIGINT quantityINTEGER movement_typeVARCHAR reference_typeVARCHAR reference_idBIGINT performed_byVARCHAR occurred_atTIMESTAMP purchase_orders idBIGINT supplier_idBIGINT warehouse_idBIGINT order_numberVARCHAR statusVARCHAR ordered_atTIMESTAMP expected_onDATE received_atTIMESTAMP purchase_order_lines idBIGINT purchase_order_idBIGINT item_idBIGINT quantity_orderedINTEGER quantity_receivedINTEGER unit_cost_minorBIGINT currency_codeCHAR shipments idBIGINT warehouse_idBIGINT shipment_numberVARCHAR external_order_re…VARCHAR carrierVARCHAR tracking_numberVARCHAR statusVARCHAR ship_to_nameVARCHAR ship_to_addressJSON shipped_atTIMESTAMP created_atTIMESTAMP shipment_lines idBIGINT shipment_idBIGINT item_idBIGINT lot_idBIGINT quantity_requestedINTEGER quantity_pickedINTEGER

Related database schemas

PostgreSQL
Commerce

E-commerce store database schema

A production-shaped e-commerce schema: products with variants, inventory per location, carts, orders with snapshotted line items, payments and shipments. Open it in the editor or export SQL for six dialects.

PostgreSQL
Fintech

Banking ledger database schema (double-entry)

A double-entry bank ledger: accounts in a single currency each, balanced journal entries that are never updated, card authorizations that hold funds, transfers kept separate from postings, and frozen statements.

MySQL
Travel

Hotel booking & reservation database schema

A reservation system that actually handles availability: room types versus rooms, rate plans, a per-night rate and inventory calendar, reservations broken down by night, payments and verified reviews.

PostgreSQL
Logistics

Vehicle fleet management database schema

How a vehicle fleet is modelled: vehicles and drivers, licence entitlements with expiry, assignment history, downsampled telematics and fault codes, maintenance due by mileage or date, work orders and parts, fuel, inspections and incidents.