情境
A gas station needs to track fuel deliveries from suppliers, storage tank readings, pump/nozzle assignments, and retail sales with line items to manage inventory and POS operations.
這張圖裡有什麼
看懂背後的決策。
01
Separate Delivery and DeliveryLine for multi-product fuel orders
02
Optional customer relation on Sale for walk-in vs fleet accounts
03
TankReading table records dip readings for reconciliation
Use when designing a database for fuel stations or similar bulk inventory with metered dispensing and point-of-sale.