Table: Security_Group
Columns
NameTypeConstraintsDescription
security_group_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLUser defined identifier (unique).
privilege_datanvarchar (1024)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.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Security_Group$security_group_KEYsecurity_group_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Security_Group$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Report_Definition_Security_Group__Security_Group__security_group_KEYsecurity_group_KEYReport_Definition_Security_Groupon delete cascade;
FK_Staff_Security_Group__Security_Group__security_group_KEYsecurity_group_KEYStaff_Security_Group

Schema diagram