Table: Report_Definition
Columns
NameTypeConstraintsDescription
report_definition_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLUser defined description.
custom_report_layoutnvarchar (-1)NOT NULLActiveReports RPX layout definition.
long_descriptionnvarchar (-1)NOT NULLLong description of report.
report_category_KEYintKey of the Report Category that this row is assigned
report_type_KEYintNOT NULLKey of the Report Type that this row is assigned
parent__report_definition_KEYintKey of the Report Definition that this row is assigned
report_definition_guiduniqueidentifierNOT NULLA database generated unique key for this table.
create_date_utcdatetimeNOT NULL
license__report_definition_guiduniqueidentifierUnique id for licensing purposes.
default_report_layoutnvarchar (100)NOT NULLDefault report layout XML resource.
Primary key
NameColumnsDescription
PK_Report_Definition$report_definition_KEYreport_definition_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Report_Definition$report_definition_guidreport_definition_guidEach report is identified by a unique identifier.
Indexes
NameColumnsDescription
IX_Report_Definition$license__report_definition_guidlicense__report_definition_guidIndex supports foreign key FK_Report_Definition__Report_Definition__license__report_definition_guid
IX_Report_Definition$parent__report_definition_KEYparent__report_definition_KEYIndex supports foreign key FK_Report_Definition__Report_Definition__parent__report_definition_KEY
IX_Report_Definition$report_category_KEYreport_category_KEYIndex supports foreign key FK_Report_Definition__Report_Category__report_category_KEY
IX_Report_Definition$report_type_KEYreport_type_KEYIndex supports foreign key FK_Report_Definition__Report_Type__report_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Definition__Report_Category__report_category_KEYreport_category_KEYReport_Category
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Report_Definition_Product__Report_Definition__report_definition_guidreport_definition_guidReport_Definition_Producton delete cascade;
FK_Report_Definition_Security_Group__Report_Definition__report_definition_guidreport_definition_guidReport_Definition_Security_Groupon delete cascade;
FK_Firm__Report_Definition__invoice__report_definition_KEYinvoice__report_definition_KEYFirm
FK_Firm__Report_Definition__statement__report_definition_KEYstatement__report_definition_KEYFirm
FK_Client__Report_Definition__invoice__report_definition_KEYinvoice__report_definition_KEYClient
FK_Client__Report_Definition__statement__report_definition_KEYstatement__report_definition_KEYClient
FK_Staff_Report_Definition__Report_Definition__report_definition_KEYreport_definition_KEYStaff_Report_Definitionon delete cascade;
FK_Print_Option__Report_Definition__label__report_definition_KEYlabel__report_definition_KEYPrint_Option
FK_Print_Option__Report_Definition__letter__report_definition_KEYletter__report_definition_KEYPrint_Option
FK_Report_Based_Portlet__Report_Definition__report_definition_KEYreport_definition_KEYReport_Based_Portlet
FK_Report_Profile_Report_Definition__Report_Definition__report_definition_KEYreport_definition_KEYReport_Profile_Report_Definitionon delete cascade;
FK_Invoice__Report_Definition__report_definition_KEYreport_definition_KEYInvoice
FK_Report_Definition_Update_List__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition_Update_Liston delete cascade;

Schema diagram