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 (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. |
client_KEY | int | NOT NULL | The client who own this solution group. |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | 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; |