Entity Definition

Logical Name : Competitor
Physical Name : PA_CMP

A retailer with a product range and customer base similar to those for the store.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CompetitorID (PK) The unique identifier assigned to a competitor by the store. ID_CMP Identity integer
OpenDate The date the competitor opened. DC_OPN_CMP DateCalendar date
CloseDate The date the date the competitor closed DE_CL_CMP DateCalendar date
StatusCode The current status of the competitor. SC_CMP Code2Status char(2)
PartyRoleAssignmentID (FK) Token identifier for a PartyRoleAssignmentInstance. ID_PRTY_RO_ASGMT Identity integer PartyRoleAssignment(PA_RO_PRTY)


Parent Entity Verb Phrase Child Entity
PartyRoleAssignment is a Competitor
Competitor sells CompetitorRetailItem
Competitor instigates DataMaintenanceEvent

Logical Views containing Competitor

Logical View
Logical 01300 - Item Price Maintenance View
Logical 06310 - Party - Role View
Logical 06700 - Event Scheduler View