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 |