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
NameTypeConstraintsDescription
client_shortcut_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
client_shortcut_group_KEYintNOT NULLAssociates this solution with its solution group.
targetnvarchar (2048)NOT NULLTarget to execute. File name or url.
descriptionnvarchar (260)NOT NULLThe length of 260 was chosen since it fits within unique constraints and it is the maximum possible length of a file path in Windows.
sortintNOT NULLA 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
NameColumnsDescription
PK_Client_Shortcut$client_shortcut_KEYclient_shortcut_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Client_Shortcut$client_shortcut_group_KEY$descriptionclient_shortcut_group_KEY, descriptionEach shortcuts description must be unique per group.
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Shortcut__Client_Shortcut_Group__client_shortcut_group_KEYclient_shortcut_group_KEYClient_Shortcut_Groupon delete cascade;

Schema diagram