Table: Report_Based_Portlet
Information about report-based custom portlets.
Columns
NameTypeConstraintsDescription
report_based_portlet_KEYintNOT NULLPrimary key
report_definition_KEYintNOT NULLKey of the report definition of the report that this report-based portlet will display.
custom_portlet_KEYintNOT NULLKey of the Custom_Portlet row that this table holds additional information for.
filter_by_dashboard_contextbitNOT NULL
Primary key
NameColumnsDescription
PK_Report_Based_Portlet$report_based_portlet_KEYreport_based_portlet_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Report_Based_Portlet$custom_portlet_KEYcustom_portlet_KEYEach Custom_Portlet row can only have one or zero Report_Based_Portlet rows.
Indexes
NameColumnsDescription
IX_Report_Based_Portlet$report_definition_KEYreport_definition_KEYIndex supports foreign key FK_Report_Based_Portlet__Report_Definition__report_definition_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Based_Portlet__Custom_Portlet__custom_portlet_KEYcustom_portlet_KEYCustom_Portleton delete cascade;
FK_Report_Based_Portlet__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition

Schema diagram