AssociatedEquipment

Entity Definition

Logical Name : AssociatedEquipment
Physical Name : ST_ASCTN_EQ

A sub-device that is connected to a another piece of Equipment. This may be used to record the relationship between a POS workstation and a fiscal printer or a POS Workstation and an electronic signature capture device.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EquipmentID (FK)(PK) The fixed asset number assigned by the retailer for the main piece of equipment that has the sub-device connected to it. ID_EQ Identity integer Equipment(AS_EQ)
ComponentEquipmentID (FK)(PK) The fixed asset number assigned by the retailer for the sub-device that is connected to the main piece of equipment. ID_EQ_CMP Identity integer Equipment(AS_EQ)

Relationships

Parent Entity Verb Phrase Child Entity
Equipment is a component AssociatedEquipment
Equipment has components AssociatedEquipment

Logical Views containing AssociatedEquipment

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 06400 - Store Equipment View