SRCHCONFEXT

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

Column Descriptions:

Name	Type	Description
SRCHCONFEXT_ID	BIGINT NOT NULL	The primary key for the table.
INDEXTYPE	VARCHAR (128) NOT NULL	The type of search index. For example, Catentry.
INDEXSCOPE	VARCHAR (128) NOT NULL	The scope of the indexed data. For example, master catalog.
LANGUAGE_ID	INTEGER	The language ID that is indexed.
INDEXSUBTYPE	VARCHAR (128) NOT NULL	The subtype of the search index. For example, Structured.
CONFIG	VARCHAR (2000) NOT NULL	The detailed configuration of the index.
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>	SRCHCONFEXT_ID	Primary Key
I0001422	INDEXSCOPE+INDEXTYPE+LANGUAGE_ID+INDEXSUBTYPE	Unique Index
I0001423	LANGUAGE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3709	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_3710	INDEXTYPE+INDEXSCOPE	SRCHCONF	INDEXTYPE+INDEXSCOPE	Cascade