Settings table for sponsorship opportunity search
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| 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) |
yes |
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) |
yes |
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) |
yes |
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 |
yes |
|
Simple search fields |
| ADVANCEDFIELDSLIST |
xml |
yes |
|
Advanced search fields |
| OUTPUTFIELDSLIST |
xml |
yes |
|
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 |
yes |
|
Id of the query view for search |
| QUERYID |
uniqueidentifier |
yes |
|
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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| SPONSORSHIPFORMPAGEID |
int |
|
Default = 0 |
Id for a page containing a sponsorship form |
| RESULTSFROMQUERY |
int |
|
Default = 0 |
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS_DATEADDED |
DATEADDED |
|
|
yes |
| IX_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS_DATECHANGED |
DATECHANGED |
|
|
|
| PK_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS |
ID |
yes |
yes |
|
Triggers
Referenced by