Table: Client_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
client_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 |
client_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_Client_Shortcut$client_shortcut_KEY | client_shortcut_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Client_Shortcut$client_shortcut_group_KEY$description | client_shortcut_group_KEY, description | Each shortcuts description must be unique per group.

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Shortcut__Client_Shortcut_Group__client_shortcut_group_KEY | client_shortcut_group_KEY | Client_Shortcut_Group | on delete cascade;