Entity Definition

Logical Name : WorkerServerAssignment
Physical Name : CO_ASGMT_WRKR_SRV

A permanent or temporary assignment of a Worker to a particular Server, allowing the Worker to be recorded as a participant in FoodService transactions.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkerID (FK)(PK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
ServerID (FK)(PK) A unique system assigned identifier for the Server. ID_SRV Identity integer Server(PA_SRV)


Parent Entity Verb Phrase Child Entity
Server is assigned via WorkerServerAssignment
Worker works as WorkerServerAssignment

Logical Views containing WorkerServerAssignment

Logical View
Logical 02360 - Retail Transaction - Food Service View
Logical 06310 - Party - Role View
Logical 11100 - Worker - Macro View
Logical 11140 - Worker - Retail Transaction View