Table: dbo.Custom_Portlet
Columns
NameTypeConstraintsDescription
custom_portlet_KEYint (4)NOT NULLKey assigned to identify this record.
descriptionnvarchar (60)NOT NULLDescription of the portlet (unique per private__staff_KEY.)
custom_portlet_type_KEYint (4)NOT NULLReference to the type of custom portlet that this is.
private__staff_KEYint (4)Key of Staff who this portlet belongs to, null if this is a public portlet.
Primary key
NameColumnsDescription
PK_Custom_Portletcustom_portlet_KEY
Unique constraints
NameColumnsDescription
UK_Custom_Portlet$private__staff_KEY$descriptionprivate__staff_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Portlet__Custom_Portlet_Type__custom_portlet_type_KEYcustom_portlet_type_KEYCustom_Portlet_Type (custom_portlet_type_KEY)
FK_Custom_Portlet__Staff__private__staff_KEYprivate__staff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Web_Page_Portlet__Custom_Portlet__custom_portlet_KEYcustom_portlet_KEYWeb_Page_Portlet

Schema diagram