Table: dbo.Staff_Type
The table used to store system Staff types. These values are not expected to be surfaced to the user.
Columns
NameTypeConstraintsDescription
staff_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (60)NOT NULLUnique description for this record.
Primary key
NameColumnsDescription
PK_Staff_Typestaff_type_KEY
Unique constraints
NameColumnsDescription
UK_Staff_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Custom_Field__Staff_Type__staff_type_KEYstaff_type_KEYCustom_Field
FK_Security_Group__Staff_Type__staff_type_KEYstaff_type_KEYSecurity_Group
FK_Staff__Staff_Type__staff_type_KEYstaff_type_KEYStaff

Schema diagram