Table: Restricted_Clearance_Staff | |||
List of staff that have clearance to the database when it is in restricted access. | |||
Columns | |||
Name | Type | Constraints | Description |
staff_KEY | int | NOT NULL | A reference to a Staff row that may access a restricted access database. |
Primary key | |||
Name | Columns | Description | |
PK_Restricted_Clearance_Staff$staff_KEY | staff_KEY | CLUSTERED |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Restricted_Clearance_Staff__Staff__staff_KEY | staff_KEY | Staff | on delete cascade; |