Table: dbo.Recorded_Event_Object_N_Employee
Table that links a recorded event object record with an employee record.
Columns
NameTypeConstraintsDescription
recorded_event_object_KEYint (4)NOT NULLPrimary key and foreign key to Recorded_Event_Object table
employee_KEYint (4)NOT NULLForeign key to Employee table
Primary key
NameColumnsDescription
PK_Recorded_Event_Object_N_Employee$recorded_event_object_KEYrecorded_event_object_KEY
Unique constraints
NameColumnsDescription
UK_Recorded_Event_Object_N_Employee$employee_KEYemployee_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event_Object_N_Employee__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Recorded_Event_Object_N_Employee__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object (recorded_event_object_KEY)

Schema diagram