Table: Restricted_Clearance_Staff
List of staff that have clearance to the database when it is in restricted access.
Columns
NameTypeConstraintsDescription
staff_KEYintNOT NULLA reference to a Staff row that may access a restricted access database.
Primary key
NameColumnsDescription
PK_Restricted_Clearance_Staff$staff_KEYstaff_KEYCLUSTERED
Foreign keys
NameColumnsReferenced tableDescription
FK_Restricted_Clearance_Staff__Staff__staff_KEYstaff_KEYStaffon delete cascade;

Schema diagram