Table: Security_Group
Columns
NameTypeConstraintsDescription
security_group_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
descriptionnvarchar (30)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_datedatetimeNOT 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