O cenário
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.
O que há neste desenho
Entenda as decisões por trás dele.
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.