Lo scenario
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.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
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.