Entity Definition

Logical Name : FuelPump
Physical Name : AS_PMP_FUEL

The piece of EQUIPMENT on the forecourt that houses one or more FUELING POINTs

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer RetailStore(PA_STR_RTL)
FuelPumpID (PK) A unique identifier for the FuelPump ID_FUEL_PMP Identity integer
EquipmentID (FK) The fixed asset number assigned by the retailer for this particular piece of equipment. ID_EQ Identity integer Equipment(AS_EQ)


Parent Entity Verb Phrase Child Entity
RetailStore houses FuelPump
Equipment is a FuelPump
FuelPump houses FuelingPoint

Logical Views containing FuelPump

Logical View
Logical 06400 - Store Equipment View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View