USERSETTINGSLISTBUILDER
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| PATH | nvarchar(4000) | Default = '' | ||
| LISTBUILDERSETTINGS | xml | yes | ||
| CONTEXTRECORDID | nvarchar(100) | Default = '' |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| APPUSERID | uniqueidentifier | APPUSER.ID | ||
| CONTEXTRECORDTYPEID | uniqueidentifier | yes | RECORDTYPE.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_USERSETTINGSLISTBUILDER_CONTEXTRECORDID | CONTEXTRECORDID | |||
| PK_USERSETTINGSLISTBUILDER | ID | yes | yes | yes |
| UIX_USERSETTINGSLISTBUILDER_APPUSERID_PATH | APPUSERID, PATH | yes |