Logistics database schema examples and ER diagrams
What a Logistics schema usually contains
A shipment moves through states and places, and both need remembering. These templates model consignments, legs and events so you can answer where something is and where it has been.
Templates (4)
Food Delivery Database Schema
A 29-table food delivery database schema covering restaurants, menus with modifiers, orders, couriers, dispatch, tracking, refunds and payouts: free ER diagram and DBML.
- tables
- 29
- columns
- 269
- refs
- 49
Ride-Hailing App Database Schema
A 27-table ride-hailing app database schema covering riders, drivers, vehicles, dispatch offers, trips, surge pricing, fares and driver payouts: free ER diagram and DBML.
- tables
- 27
- columns
- 260
- refs
- 58
Airline Reservation Database Schema
A 34-table airline reservation database schema with flights, fares, seat inventory, PNR bookings, tickets and coupons, check-in, baggage and loyalty — free ER diagram and DBML.
- tables
- 34
- columns
- 261
- refs
- 56
Inventory Management Database Schema
A 16-table inventory management database schema with stock ledger, bin locations, purchase orders, goods receipts, transfers and cycle counts — free ER diagram and DBML.
- tables
- 16
- columns
- 126
- refs
- 29