Entity Definition

Logical Name : KeyLockEquipmentStatisticsReading
Physical Name : DO_EQRDG_KYLK

A set of performance statistics that have been taken from a key lock 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
LockPositionChangeCount Number of lock position changes. QU_CNT_LCK_PSN_CHG QuantityShortCount decimal(3,0)


Parent Entity Verb Phrase Child Entity
EquipmentStatisticsReading can be a KeyLockEquipmentStatisticsReading

Logical Views containing KeyLockEquipmentStatisticsReading

Logical View
Logical 06400 - Store Equipment View