Table: Staff_Shortcut_Group
This table is a data store for the Solutions portlets. It contains information about user-configurable groups of solutions (which are paths to files, folders, or web pages).
Columns
NameTypeConstraintsDescription
staff_shortcut_group_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
descriptionnvarchar (260)NOT NULLUser-configurable display name for the solution group.
sortintNOT NULLUser-configurable sequence number that defines the order in which the solution group will appear in the Solutions portlet.
staff_KEYintNOT NULLThe staff who own this solution group.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Staff_Shortcut_Group$staff_shortcut_group_KEYstaff_shortcut_group_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Shortcut_Group$staff_KEY$descriptionstaff_KEY, descriptionEach groups description must be unique per Staff.
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Shortcut_Group__Staff__staff_KEYstaff_KEYStaffon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Staff_Shortcut__Staff_Shortcut_Group__staff_shortcut_group_KEYstaff_shortcut_group_KEYStaff_Shortcuton delete cascade;

Schema diagram