상황
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.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
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.