| Table: dbo.Staff_Security_Group | |||
| Columns | |||
| Name | Type | Constraints | Description |
| staff_security_group_KEY | int (4) | NOT NULL | Database assigned primary key for this table. |
| staff_KEY | int (4) | NOT NULL | Foreign key to Staff. |
| security_group_KEY | int (4) | NOT NULL | Foreign key to Security Group. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Staff_Security_Group | staff_security_group_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Staff_Security_Group$staff_KEY$security_group_KEY | staff_KEY, security_group_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Staff_Security_Group__Security_Group__security_group_KEY | security_group_KEY | Security_Group (security_group_KEY) | |
| FK_Staff_Security_Group__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) | |