Table: Custom_Portlet
Columns
NameTypeConstraintsDescription
custom_portlet_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Key assigned to identify this record.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLDescription of the portlet (unique per private__staff_KEY.)
custom_portlet_type_KEYintNOT NULLReference to the type of custom portlet that this is.
private__staff_KEYintKey of Staff who this portlet belongs to, null if this is a public portlet.
Primary key
NameColumnsDescription
PK_Custom_Portlet$custom_portlet_KEYcustom_portlet_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Custom_Portlet$private__staff_KEY$descriptionprivate__staff_KEY, description
Indexes
NameColumnsDescription
IX_Custom_Portlet$custom_portlet_type_KEYcustom_portlet_type_KEYIndex supports foreign key FK_Custom_Portlet__Custom_Portlet_Type__custom_portlet_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Portlet__Custom_Portlet_Type__custom_portlet_type_KEYcustom_portlet_type_KEYCustom_Portlet_Type
FK_Custom_Portlet__Staff__private__staff_KEYprivate__staff_KEYStaffon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Feed_Portlet__Custom_Portlet__custom_portlet_KEYcustom_portlet_KEYFeed_Portleton delete cascade;
FK_Report_Based_Portlet__Custom_Portlet__custom_portlet_KEYcustom_portlet_KEYReport_Based_Portleton delete cascade;
FK_Web_Page_Portlet__Custom_Portlet__custom_portlet_KEYcustom_portlet_KEYWeb_Page_Portleton delete cascade;

Schema diagram