Table: dbo.Staff_Shortcut
Columns
NameTypeConstraintsDescription
staff_shortcut_KEYint (4)NOT NULLDatabase assigned primary key for this table
staff_KEYint (4)NOT NULLKey to a Staff row
targetnvarchar (2000)NOT NULLTarget to execute. File name or url.
portlet_type_KEYint (4)NOT NULLportlet type
Primary key
NameColumnsDescription
PK_Staff_Shortcutstaff_shortcut_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Shortcut__Portlet_Type__portlet_type_KEYportlet_type_KEYPortlet_Type (portlet_type_KEY)
FK_Staff_Shortcut__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram