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