Table: Report_Profile
Columns
NameTypeConstraintsDescription
report_profile_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLUser defined description (unique).
staff_KEYintKey of the Staff to whom the profile belongs.
create_date_utcdatetimeNOT NULL
report_type_KEYintNOT NULLKey of the Report Type that this row is assigned.
Primary key
NameColumnsDescription
PK_Report_Profile$report_profile_KEYreport_profile_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Report_Profile$staff_KEY$report_type_KEY$descriptionstaff_KEY, report_type_KEY, description
Indexes
NameColumnsDescription
IX_Report_Profile$report_type_KEYreport_type_KEYIndex supports foreign key FK_Report_Profile__Report_Type__report_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Profile__Staff__staff_KEYstaff_KEYStaffon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Report_Profile_Report_Definition__Report_Profile__report_profile_KEYreport_profile_KEYReport_Profile_Report_Definitionon delete cascade;

Schema diagram