Table: Report_Profile_Report_Definition
Columns
NameTypeConstraintsDescription
report_profile_report_definition_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
report_profile_KEYintNOT NULLKey to the Report Profile that this report is used on.
report_definition_KEYintNOT NULLKey to a Report Definition that belongs to this profile.
ordinal_positionintNOT NULLThe order of the reports in the profile.
report_optionsnvarchar (-1)NOT NULLThe report options in serialized XML format.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Report_Profile_Report_Definition$report_profile_report_definition_KEYreport_profile_report_definition_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Report_Profile_Report_Definition$report_definition_KEYreport_definition_KEYIndex supports foreign key FK_Report_Profile_Report_Definition__Report_Definition__report_definition_KEY
IX_Report_Profile_Report_Definition$report_profile_KEY$ordinal_positionreport_profile_KEY, ordinal_position
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Profile_Report_Definition__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definitionon delete cascade;
FK_Report_Profile_Report_Definition__Report_Profile__report_profile_KEYreport_profile_KEYReport_Profileon delete cascade;

Schema diagram