
🚚 Logistics & Supply Chain · Database ERD
Tables for a logistics system: customers, shipments, packages, consignment legs, hubs, vehicles and tracking events.
Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.
Drawing diagram…
Logistics database schema: customers create shipments; a shipment has one or more packages; the shipment moves in legs between hubs, each leg assigned to a vehicle; every package has tracking events (picked up, in hub, out for delivery, delivered) with location and time; proof of delivery is attached to the delivery event.
erDiagram
CUSTOMER ||--o{ SHIPMENT : books
SHIPMENT ||--|{ PACKAGE : contains
SHIPMENT ||--|{ LEG : "moves in"
HUB ||--o{ LEG : "origin of"
VEHICLE ||--o{ LEG : carries
PACKAGE ||--o{ TRACKING_EVENT : logs
TRACKING_EVENT ||--o| PROOF_OF_DELIVERY : "may have"
CUSTOMER {
int id PK
string name
string gstin
}
SHIPMENT {
int id PK
int customer_id FK
string awb_no
string service_level
}
PACKAGE {
int id PK
int shipment_id FK
decimal weight_kg
string barcode
}
LEG {
int id PK
int shipment_id FK
int from_hub_id FK
int vehicle_id FK
datetime departed_at
}
HUB {
int id PK
string code
string city
}
VEHICLE {
int id PK
string registration
string type
}
TRACKING_EVENT {
int id PK
int package_id FK
string status
datetime at
string location
}
PROOF_OF_DELIVERY {
int id PK
int event_id FK
string receiver_name
string photo_url
}An entity relationship diagram with 8 tables, 31 columns and 7 relationships.
Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.
From an order leaving the hub to the parcel at the customer's door: rider assignment, live tracking, OTP handover and proof of delivery.
A logistics platform that tracks shipments across carriers: booking, scan events from hubs, carrier integrations and customer notifications.
How a warehouse receives goods: appointment, unloading, checking against the ASN, quality check, putaway and stock update.
How a delivery company plans daily routes: orders, vehicle capacity, time windows and live traffic feed a route optimiser that assigns stops to drivers.
The states of a freight shipment booking, from quote and booking through pickup, transit, customs and delivery.
Where cold chain monitoring runs for vaccines or fresh food: temperature loggers in reefers and cold rooms, gateways, and a cloud alerting platform.