USERSETTINGSSEARCHLISTTASKHISTORY

Contains information about a user's search list task history per user.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
PARAMETERS	xml	yes		The data list's parameters from the user's last session.
DATECHANGED	datetime			The date the search list task parameters were last updated.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
SEARCHLISTCATALOGID	uniqueidentifier		SEARCHLISTCATALOG.ID	The ID of the search list.
TASKCATALOGID	uniqueidentifier		TASKCATALOG.ID	The ID of the task that invoked the search list.
APPUSERID	uniqueidentifier		APPUSER.ID	The ID of the app user to which the settings belong.

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_USERSETTINGSSEARCHLISTTASKHISTORY	ID	yes	yes	yes
UIX_USERSETTINGSSEARCHLISTTASKHISTORY_APPUSERID_SEARCHLISTCATALOGID_TASKCATALOGID	APPUSERID, SEARCHLISTCATALOGID, TASKCATALOGID	yes