Table: Staff_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 |
staff_shortcut_group_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
description | nvarchar (260) | 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. |
staff_KEY | int | NOT NULL | The staff 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_Staff_Shortcut_Group$staff_shortcut_group_KEY | staff_shortcut_group_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Staff_Shortcut_Group$staff_KEY$description | staff_KEY, description | Each groups description must be unique per Staff. |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Staff_Shortcut_Group__Staff__staff_KEY | staff_KEY | Staff | on delete cascade; |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Staff_Shortcut__Staff_Shortcut_Group__staff_shortcut_group_KEY | staff_shortcut_group_KEY | Staff_Shortcut | on delete cascade; |