| Table: dbo.Staff_Ems_User_Id | |||
| Maps Staff to the EMS User ID, if needed. (EMS being the CSi interal user license management system.) | |||
| Columns | |||
| Name | Type | Constraints | Description |
| staff_KEY | int (4) | NOT NULL | Primary key |
| ems_user_id | int (4) | NOT NULL | The associated EMS User ID. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Staff_Ems_User_Id$staff_KEY | staff_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Staff_Ems_User_Id$ems_user_id | ems_user_id | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Staff_Ems_User_Id__Ems_User__ems_user_id | ems_user_id | Ems_User (ems_user_id) | |
| FK_Staff_Ems_User_Id__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) | |