El escenario
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.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
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.