Table: dbo.Recorded_Event_Object_N_Payroll_Department
Table that links a recorded event object record with a Payroll_Department.
Columns
NameTypeConstraintsDescription
recorded_event_object_KEYint (4)NOT NULLPrimary key and foreign key to Recorded_Event_Object table
payroll_department_KEYint (4)NOT NULLForeign key to Payroll_Department table
Primary key
NameColumnsDescription
PK_Recorded_Event_Object_N_Payroll_Department$recorded_event_object_KEYrecorded_event_object_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event_Object_N_Payroll_Department__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Department (payroll_department_KEY)
FK_Recorded_Event_Object_N_Payroll_Department__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object (recorded_event_object_KEY)

Schema diagram