情境
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.