Table: dbo.Security_Group
Columns
NameTypeConstraintsDescription
security_group_KEYint (4)NOT NULLDatabase assigned primary key for this table.
descriptionnvarchar (60)NOT NULLUser defined identifier (unique).
privilege_datanvarchar (4096)NOT NULLA string of 1's and 0's that holds the privileges for this Security Group. The position in the string (0 based) corresponds to Privilege.privilege_KEY.
staff_type_KEYint (4)NOT NULLType of staff this group can be assigned to.
Primary key
NameColumnsDescription
PK_Security_Groupsecurity_group_KEY
Unique constraints
NameColumnsDescription
UK_Security_Group$descriptiondescription
Foreign keys
NameColumnsReferenced tableDescription
FK_Security_Group__Staff_Type__staff_type_KEYstaff_type_KEYStaff_Type (staff_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Report_Definition_Security_Group__Security_Group__security_group_KEYsecurity_group_KEYReport_Definition_Security_Group
FK_Staff_Security_Group__Security_Group__security_group_KEYsecurity_group_KEYStaff_Security_Group

Schema diagram