Table: dbo.Recorded_Event_Object_N_Payroll_Department
Table that links a recorded event object record with a Payroll_Department.
Columns
Name | Type | Constraints | Description
recorded_event_object_KEY | int (4) | NOT NULL | Primary key and foreign key to Recorded_Event_Object table
payroll_department_KEY | int (4) | NOT NULL | Foreign key to Payroll_Department table

Primary key
Name | Columns | Description
PK_Recorded_Event_Object_N_Payroll_Department$recorded_event_object_KEY | recorded_event_object_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Recorded_Event_Object_N_Payroll_Department__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Department (payroll_department_KEY) |
FK_Recorded_Event_Object_N_Payroll_Department__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object (recorded_event_object_KEY) |