Table: Staff_Shortcut
This table is a data store for the Solutions portlets. It contains information about user-configurable solutions (which are paths to files, folders, or web pages).
Columns
Name | Type | Constraints | Description
staff_shortcut_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
create_date_utc | datetime | NOT NULL |
staff_shortcut_group_KEY | int | NOT NULL | Associates this solution with its solution group.
target | nvarchar (2048) | NOT NULL | Target to execute. File name or url.
description | nvarchar (260) | NOT NULL | The length of 260 was chosen since it fits within unique constraints and it is the maximum possible length of a file path in Windows.
sort | int | NOT NULL | A value indicating what order to sort items in. Ideally this would be constrained to be unique per shortcut group, but that adds unneccessary complication to the code that saves these records.

Primary key
Name | Columns | Description
PK_Staff_Shortcut$staff_shortcut_KEY | staff_shortcut_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Staff_Shortcut$staff_shortcut_group_KEY$description | staff_shortcut_group_KEY, description | Each shortcuts description must be unique per group.

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_Shortcut__Staff_Shortcut_Group__staff_shortcut_group_KEY | staff_shortcut_group_KEY | Staff_Shortcut_Group | on delete cascade;