SRCHTERMASSOC

This table contains search term associations to suggest additional, different, or replacement products in search results. Search term associations include synonyms, replacement terms, and landing pages.

Column Descriptions:

NameTypeDescription
SRCHTERMASSOC_IDBIGINT NOT NULLGenerated primary key
ASSOCIATIONTYPEINTEGER NOT NULL1: Synonyms 2: Also search for 3: Search for instead 4: Landing page
STOREENT_IDINTEGER NOT NULLThe store where this association is defined.
LANGUAGE_IDINTEGER NOT NULLThe language for which this association is defined.
STATUSINTEGER NOT NULL1: Record needs to be published to search engine 0: Record does not need to be published to search engine, for example Landing pages and multi-word configurations
SCOPEVARCHAR (128)Extra context information for this search term association, for example the master catalog ID
TYPEVARCHAR (128)The type of search index. For example, Catentry or Catalog.
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_IDPrimary Key
I0001396STOREENT_IDNon-Unique Index
I0001397LANGUAGE_IDNon-Unique Index
I0001398SCOPENon-Unique Index
I0001399STATUSNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3686STOREENT_IDSTOREENTSTOREENT_IDCascade
F_3687LANGUAGE_IDLANGUAGELANGUAGE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3688SRCHTERMASSOC_IDSRCHTERMSRCHTERMASSOC_IDCascade