Table: dbo.Recorded_Event_Object_N_Staff
Table that links a recorded event object record with an staff record.
Columns
NameTypeConstraintsDescription
recorded_event_object_KEYint (4)NOT NULLPrimary key and foreign key to Recorded_Event_Object table
staff_KEYint (4)NOT NULLForeign key to Staff table
Primary key
NameColumnsDescription
PK_Recorded_Event_Object_N_Staff$recorded_event_object_KEYrecorded_event_object_KEY
Unique constraints
NameColumnsDescription
UK_Recorded_Event_Object_N_Staff$staff_KEYstaff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event_Object_N_Staff__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object (recorded_event_object_KEY)
FK_Recorded_Event_Object_N_Staff__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram