Table: Staff_Report_Definition
Columns
NameTypeConstraintsDescription
staff_report_definition_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
staff_KEYintNOT NULLKey to the staff to whom these default options belong.
report_definition_KEYintNOT NULLKey to a Report Definition to which these default options belong.
default_optionsnvarchar (-1)NOT NULLThe default report options in serialized XML format.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Staff_Report_Definition$staff_report_definition_KEYstaff_report_definition_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Staff_Report_Definition$report_definition_KEYreport_definition_KEYIndex supports foreign key FK_Staff_Report_Definition__Report_Definition__report_definition_KEY
IX_Staff_Report_Definition$staff_KEYstaff_KEYIndex supports foreign key FK_Staff_Report_Definition__Staff__staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Report_Definition__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definitionon delete cascade;
FK_Staff_Report_Definition__Staff__staff_KEYstaff_KEYStaffon delete cascade;

Schema diagram