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). |
client_shortcut_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | datetime | NOT NULL | |
client_shortcut_group_KEY | int | NOT NULL | Associates this solution with its solution group. |
target | nvarchar (2048) | NOT NULL | Target to execute. File name or url. |
description | nvarchar (260) | NOT NULL | The length of 260 was chosen since it fits within unique constraints and it is the maximum possible length of a file path in Windows. |
sort | int | NOT NULL | A 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. |