Table: dbo.Report_Definition_Security_Group
Each record indicates that the report is available to staff who are in the specified security group
Columns
NameTypeConstraintsDescription
report_definition_security_group_KEYint (4)NOT NULLPrimary key for the table.
report_definition_KEYint (4)NOT NULLKey of report that's being granted access to.
security_group_KEYint (4)NOT NULLSecurity group that the report is being granted access in.
Primary key
NameColumnsDescription
PK_Report_Definition_Security_Groupreport_definition_security_group_KEY
Unique constraints
NameColumnsDescription
UK_Report_Definition_Security_Group$security_group_KEY$report_definition_KEYsecurity_group_KEY, report_definition_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Definition_Security_Group__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition (report_definition_KEY)
FK_Report_Definition_Security_Group__Security_Group__security_group_KEYsecurity_group_KEYSecurity_Group (security_group_KEY)

Schema diagram