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
NameTypeConstraintsDescription
staff_KEYint (4)NOT NULLPrimary key
ems_user_idint (4)NOT NULLThe associated EMS User ID.
Primary key
NameColumnsDescription
PK_Staff_Ems_User_Id$staff_KEYstaff_KEY
Unique constraints
NameColumnsDescription
UK_Staff_Ems_User_Id$ems_user_idems_user_id
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Ems_User_Id__Ems_User__ems_user_idems_user_idEms_User (ems_user_id)
FK_Staff_Ems_User_Id__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram