SRCHTERM

This table contains search terms that a customer searches for, either as their inputted search term, or the substituted search term associations.

Column Descriptions:

NameTypeDescription
SRCHTERMASSOC_IDBIGINT NOT NULLForeign key to SRCHTERMASSOC table
TYPEINTEGER NOT NULL1: Input term 2: Associated term
TERMVARCHAR (254) NOT NULLAn input search term that a customer would search with, or an associated term that should be used along with or instead of the input term.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SRCHTERMASSOC_ID+TYPE+TERMPrimary Key
I0001400TERMNon-Unique Index
I0001401TYPENon-Unique Index
I0001402SRCHTERMASSOC_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3688SRCHTERMASSOC_IDSRCHTERMASSOCSRCHTERMASSOC_IDCascade