Table: Report_Definition
Columns
Name | Type | Constraints | Description
report_definition_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
description | nvarchar (250) | NOT NULL | User defined description.
custom_report_layout | nvarchar (-1) | NOT NULL | ActiveReports RPX layout definition.
long_description | nvarchar (-1) | NOT NULL | Long description of report.
report_category_KEY | int |  | Key of the Report Category that this row is assigned
report_type_KEY | int | NOT NULL | Key of the Report Type that this row is assigned
parent__report_definition_KEY | int |  | Key of the Report Definition that this row is assigned
report_definition_guid | uniqueidentifier | NOT NULL | A database generated unique key for this table.
create_date_utc | datetime | NOT NULL |
license__report_definition_guid | uniqueidentifier |  | Unique id for licensing purposes.
default_report_layout | nvarchar (100) | NOT NULL | Default report layout XML resource.

Primary key
Name | Columns | Description
PK_Report_Definition$report_definition_KEY | report_definition_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Report_Definition$report_definition_guid | report_definition_guid | Each report is identified by a unique identifier.
Indexes
Name | Columns | Description
IX_Report_Definition$license__report_definition_guid | license__report_definition_guid | Index supports foreign key FK_Report_Definition__Report_Definition__license__report_definition_guid
IX_Report_Definition$parent__report_definition_KEY | parent__report_definition_KEY | Index supports foreign key FK_Report_Definition__Report_Definition__parent__report_definition_KEY
IX_Report_Definition$report_category_KEY | report_category_KEY | Index supports foreign key FK_Report_Definition__Report_Category__report_category_KEY
IX_Report_Definition$report_type_KEY | report_type_KEY | Index supports foreign key FK_Report_Definition__Report_Type__report_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Report_Definition__Report_Category__report_category_KEY | report_category_KEY | Report_Category |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Report_Definition_Product__Report_Definition__report_definition_guid | report_definition_guid | Report_Definition_Product | on delete cascade;
FK_Report_Definition_Security_Group__Report_Definition__report_definition_guid | report_definition_guid | Report_Definition_Security_Group | on delete cascade;
FK_Client__Report_Definition__invoice__report_definition_KEY | invoice__report_definition_KEY | Client |
FK_Client__Report_Definition__statement__report_definition_KEY | statement__report_definition_KEY | Client |
FK_Staff_Report_Definition__Report_Definition__report_definition_KEY | report_definition_KEY | Staff_Report_Definition | on delete cascade;
FK_Print_Option__Report_Definition__label__report_definition_KEY | label__report_definition_KEY | Print_Option |
FK_Print_Option__Report_Definition__letter__report_definition_KEY | letter__report_definition_KEY | Print_Option |
FK_Report_Based_Portlet__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Based_Portlet |
FK_Report_Profile_Report_Definition__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Profile_Report_Definition | on delete cascade;
FK_Firm__Report_Definition__invoice__report_definition_KEY | invoice__report_definition_KEY | Firm |
FK_Firm__Report_Definition__statement__report_definition_KEY | statement__report_definition_KEY | Firm |
FK_Invoice__Report_Definition__report_definition_KEY | report_definition_KEY | Invoice |
FK_Report_Definition_Update_List__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Definition_Update_List | on delete cascade;