The scenario
A fuel logistics company needs an ERD to support dispatch planning and route optimization for fuel orders delivered from depots to customers via assigned drivers and vehicles.
What is in this drawing
Read the decisions behind it.
01
Model FuelOrder separately from DeliveryStop so a route can sequence multiple order stops.
02
Include optimizer_version and optimized_distance_km on Route to capture route optimization results.
03
Use many-mandatory to one-mandatory refs from child FK tables to parent tables.
Reusable for dispatch systems, fuel delivery scheduling, or any route-based logistics where orders map to stops on optimized routes.
More like this