Entity Definition

Logical Name : MotionSensorEquipmentStatisticsReading
Physical Name : DO_EQRDG_MTN_SNSR

A set of performance statistics that have been taken from a motion sensor (or traffic counter) 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
MotionEventCount Number of motion occurrances detected. QU_MTN_CNT QuantityShortCount decimal(3,0)


Parent Entity Verb Phrase Child Entity
EquipmentStatisticsReading can be a MotionSensorEquipmentStatisticsReading

Logical Views containing MotionSensorEquipmentStatisticsReading

Logical View
Logical 06400 - Store Equipment View