Table: Firm_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
firm_shortcut_group_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
description | nvarchar (250) | 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.
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
create_date_utc | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Firm_Shortcut_Group$firm_shortcut_group_KEY | firm_shortcut_group_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Firm_Shortcut_Group$description | description | Each groups description must be unique per Firm.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Firm_Shortcut__Firm_Shortcut_Group__firm_shortcut_group_KEY | firm_shortcut_group_KEY | Firm_Shortcut | on delete cascade;