Table: Client_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
client_shortcut_group_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
description | nvarchar (50) | 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.
client_KEY | int | NOT NULL | The client 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_Client_Shortcut_Group$client_shortcut_group_KEY | client_shortcut_group_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Client_Shortcut_Group__client_KEY__description | client_KEY, description | Each groups description must be unique per Client.

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Shortcut_Group__Client__client_KEY | client_KEY | Client | on delete cascade;

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_Shortcut__Client_Shortcut_Group__client_shortcut_group_KEY | client_shortcut_group_KEY | Client_Shortcut | on delete cascade;