Entity Definition

Logical Name : EquipmentClass
Physical Name : AS_EQ_CLS

A class of device used as an as interface to any store business function. All instances of the class have a common manufacturer, service provider and supplier. Class instanaces are currently Workstation, FuelPump, TankGuage and TankProbe.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EquipmentClassID (PK) A unique identifier for the class of equipment. ID_EQ_CLS Identity integer
SupplierID (FK) A unique system assigned identifier for the Supplier. ID_SPR Identity integer Supplier(PA_SPR)
ServiceProviderID (FK) A unique system assigned identifier for the Service Provider. ID_PVR_SV Identity integer ServiceProvider(PA_PVR_SV)
ManufacturerName The name of the hardware manufacturer NM_MF Name varchar(40)


Parent Entity Verb Phrase Child Entity
Supplier supplies EquipmentClass
ServiceProvider services EquipmentClass
EquipmentClass classifies Equipment

Logical Views containing EquipmentClass

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01040 - Item Description - Rental View
Logical 06400 - Store Equipment View
Logical 20000 - Forecourt Macro View