Table: Custom_Portlet
Columns
Name | Type | Constraints | Description
custom_portlet_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Key assigned to identify this record.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
description | nvarchar (30) | NOT NULL | Description of the portlet (unique per private__staff_KEY.)
custom_portlet_type_KEY | int | NOT NULL | Reference to the type of custom portlet that this is.
private__staff_KEY | int |  | Key of Staff who this portlet belongs to, null if this is a public portlet.

Primary key
Name | Columns | Description
PK_Custom_Portlet$custom_portlet_KEY | custom_portlet_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Custom_Portlet__private__staff_KEY__description | private__staff_KEY, description |
Indexes
Name | Columns | Description
IX_Custom_Portlet$custom_portlet_type_KEY | custom_portlet_type_KEY | Index supports foreign key FK_Custom_Portlet__Custom_Portlet_Type__custom_portlet_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Custom_Portlet__Custom_Portlet_Type__custom_portlet_type_KEY | custom_portlet_type_KEY | Custom_Portlet_Type |
FK_Custom_Portlet__Staff__private__staff_KEY | private__staff_KEY | Staff | on delete cascade;

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Feed_Portlet__Custom_Portlet__custom_portlet_KEY | custom_portlet_KEY | Feed_Portlet | on delete cascade;
FK_Report_Based_Portlet__Custom_Portlet__custom_portlet_KEY | custom_portlet_KEY | Report_Based_Portlet | on delete cascade;
FK_Web_Page_Portlet__Custom_Portlet__custom_portlet_KEY | custom_portlet_KEY | Web_Page_Portlet | on delete cascade;