Entity Definition

Logical Name : BumpBarEquipmentStatisticsReading
Physical Name : DO_EQRDG_BMPBR

A set of performance statistics that have been taken from a bump bar connected to a Workstation.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EquipmentID (FK)(PK) The fixed asset number assigned by the retailer for this particular piece of equipment. ID_EQ Identity integer
TimeStamp (FK)(PK) The date and time that the EquipmentStatisticsReading was made. TS_RDG AuditDateTime datetime
BumpCount The number of times the BumpBar has been bumped since the last statistics reading. QU_CNT_BMP QuantityShortCount decimal(3,0)


Parent Entity Verb Phrase Child Entity
EquipmentStatisticsReading can be a BumpBarEquipmentStatisticsReading

Logical Views containing BumpBarEquipmentStatisticsReading

Logical View
Logical 06400 - Store Equipment View