Table: dbo.Recorded_Event_Object_N_Staff | |||
Table that links a recorded event object record with an staff record. | |||
Columns | |||
Name | Type | Constraints | Description |
recorded_event_object_KEY | int (4) | NOT NULL | Primary key and foreign key to Recorded_Event_Object table |
staff_KEY | int (4) | NOT NULL | Foreign key to Staff table |
Primary key | |||
Name | Columns | Description | |
PK_Recorded_Event_Object_N_Staff$recorded_event_object_KEY | recorded_event_object_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Recorded_Event_Object_N_Staff$staff_KEY | staff_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Recorded_Event_Object_N_Staff__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object (recorded_event_object_KEY) | |
FK_Recorded_Event_Object_N_Staff__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |