TankTemperatureReading

Entity Definition

Logical Name : TankTemperatureReading
Physical Name : DO_RDG_TNK_TEMP

A reading of the temperature of the Fuel that is stored in a Tank.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TankID (FK)(PK) A unique identifier for this Tank ID_TNK Identity integer TankTemperatureSensor(AS_SNSR_TEMP)
TankTemperatureSensorID (FK)(PK) A unique identifier for the TemperatureSensor in a particular Tank ID_SNSR_TNK_TEMP Identity integer TankTemperatureSensor(AS_SNSR_TEMP)
BusinessUnitID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer TankTemperatureSensor(AS_SNSR_TEMP)
ReadingNumber (PK) A unique identifier for this reading of a particular TankTemperatureSensor AI_RDG Number integer
DateTime The date & time the TemperatureReading was taken. TS_RDG AuditDateTime datetime
Temperature The measured temperature QU_TEMP Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
TankTemperatureSensor records TankTemperatureReading

Logical Views containing TankTemperatureReading

Logical View
Logical 20000 - Forecourt Macro View
Logical 20050 - Forecourt Tank Gauge View