USERSETTINGSDATALIST
Contains information about data list customizations per user.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| PATH | nvarchar(4000) | Default = '' | The path to the data list. | |
| PARAMETERS | xml | yes | The data list's parameters from the user's last session. |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| APPUSERID | uniqueidentifier | APPUSER.ID | The ID of the app user to which the settings belong. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_USERSETTINGSDATALIST | ID | yes | yes | yes |
| UIX_USERSETTINGSDATALIST_APPUSERID_PATH | APPUSERID, PATH | yes |