SRCHCONFEXT

The configuration table extended for SRCHCONF for HCL Commerce search integration.

Column Descriptions:

NameTypeDescription
SRCHCONFEXT_IDBIGINT NOT NULLThe primary key for the table.
INDEXTYPEVARCHAR (128) NOT NULLThe type of search index. For example, Catentry.
INDEXSCOPEVARCHAR (128) NOT NULLThe scope of the indexed data. For example, master catalog.
LANGUAGE_IDINTEGERThe language ID that is indexed.
INDEXSUBTYPEVARCHAR (128) NOT NULLThe subtype of the search index. For example, Structured.
CONFIGVARCHAR (2000) NOT NULLThe detailed configuration of the index.
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>SRCHCONFEXT_IDPrimary Key
I0001422INDEXSCOPE+INDEXTYPE+LANGUAGE_ID+INDEXSUBTYPEUnique Index
I0001423LANGUAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3709LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_3710INDEXTYPE+INDEXSCOPESRCHCONFINDEXTYPE+INDEXSCOPECascade