Table: Report_Definition_Security_Group
Columns
NameTypeConstraintsDescription
report_definition_security_group_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
report_definition_guiduniqueidentifierNOT NULLForeign key to Report Definition.
security_group_KEYintNOT NULLForeign key to Security Group.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Report_Definition_Security_Group$report_definition_security_group_KEYreport_definition_security_group_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Report_Definition_Security_Group$report_definition_guid$security_group_KEYreport_definition_guid, security_group_KEY
Indexes
NameColumnsDescription
IX_Report_Definition_Security_Group$security_group_KEYsecurity_group_KEYIndex supports foreign key FK_Report_Definition_Security_Group__Security_Group__security_group_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Definition_Security_Group__Report_Definition__report_definition_guidreport_definition_guidReport_Definitionon delete cascade;
FK_Report_Definition_Security_Group__Security_Group__security_group_KEYsecurity_group_KEYSecurity_Groupon delete cascade;

Schema diagram