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) |