Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEARCHRESULTHTML nvarchar(max)   Default = '' Html and merge fields for search results
 SEARCHCRITERIADESIGNCODE tinyint   Default = 0 Table or div based search criteria layout
 SEARCHCRITERIADESIGN nvarchar(5) (Computed) CASE [SEARCHCRITERIADESIGNCODE] WHEN 0 THEN N'Table' WHEN 1 THEN N'Div' END Provides a translation for the 'SEARCHCRITERIADESIGNCODE' field.
 HTMLSEARCHRESULTCODE tinyint   Default = 0 Table or div for search result layout
 HTMLSEARCHRESULT nvarchar(5) (Computed) CASE [HTMLSEARCHRESULTCODE] WHEN 0 THEN N'Table' WHEN 1 THEN N'Div' END Provides a translation for the 'HTMLSEARCHRESULTCODE' field.
 SHOWPAGINGCONTROLSCODE tinyint   Default = 0 Codes for paging controls layout on the form
 SHOWPAGINGCONTROLS nvarchar(6) (Computed) CASE [SHOWPAGINGCONTROLSCODE] WHEN 0 THEN N'Both' WHEN 1 THEN N'Top' WHEN 2 THEN N'Bottom' END Provides a translation for the 'SHOWPAGINGCONTROLSCODE' field.
 AUTOSEARCHENABLED bit   Default = 0 Flag for auto search
 SEARCHCOLUMNS int   Default = 0 Number of columns used for the search results
 SIMPLEFIELDSLIST xml Simple search fields
 ADVANCEDFIELDSLIST xml Advanced search fields
 OUTPUTFIELDSLIST xml Output fields
 RECORDSPERPAGE int   Default = 0 Number of records to show per search page
 COLUMNSPERPAGE int   Default = 0 Number of columns per search page
 RESULTSPERSESSION int   Default = 0 Number of search results per session
 QUERYVIEWID uniqueidentifier Id of the query view for search
 QUERYID uniqueidentifier Id of the query for search
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 SPONSORSHIPFORMPAGEID int   Default = 0 Id for a page containing a sponsorship form

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS_DATEADDED DATEADDED    
 IX_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS_DATECHANGED DATECHANGED      
 PK_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS ID  

Trigger Name Description
 TR_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS_AUDIT_UPDATE
 TR_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS_AUDIT_DELETE

Referenced by Field
 SPONSORSHIPOPPORTUNITYSEARCHCMSMASKINGIMAGES SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGSID

Entity-Relationship diagram of this table