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:

Name	Type	Description
SRCHTERMASSOC_ID	BIGINT NOT NULL	Generated primary key
ASSOCIATIONTYPE	INTEGER NOT NULL	1: Synonyms 2: Also search for 3: Search for instead 4: Landing page
STOREENT_ID	INTEGER NOT NULL	The store where this association is defined.
LANGUAGE_ID	INTEGER NOT NULL	The language for which this association is defined.
STATUS	INTEGER NOT NULL	1: 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
SCOPE	VARCHAR (128)	Extra context information for this search term association, for example the master catalog ID
TYPE	VARCHAR (128)	The type of search index. For example, Catentry or Catalog.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	SRCHTERMASSOC_ID	Primary Key
I0001396	STOREENT_ID	Non-Unique Index
I0001397	LANGUAGE_ID	Non-Unique Index
I0001398	SCOPE	Non-Unique Index
I0001399	STATUS	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3686	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_3687	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3688	SRCHTERMASSOC_ID	SRCHTERM	SRCHTERMASSOC_ID	Cascade