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
Name | Type | Constraints | Description
staff_shortcut_group_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
description | nvarchar (260) | NOT NULL | User-configurable display name for the solution group.
sort | int | NOT NULL | User-configurable sequence number that defines the order in which the solution group will appear in the Solutions portlet.
staff_KEY | int | NOT NULL | The staff who own this solution group.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Staff_Shortcut_Group$staff_shortcut_group_KEY | staff_shortcut_group_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Staff_Shortcut_Group__staff_KEY__description | staff_KEY, description | Each groups description must be unique per Staff.

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_Shortcut_Group__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Staff_Shortcut__Staff_Shortcut_Group__staff_shortcut_group_KEY | staff_shortcut_group_KEY | Staff_Shortcut | on delete cascade;