WebSphere Commerce database table: SRCHCONF

SRCHCONF

The configuration table for WebSphere Commerce search integration.

Column Descriptions:

Name Type Description
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.
LANGUAGES VARCHAR (1600) NOT NULL The languages that the data is indexed in.
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> INDEXTYPE+INDEXSCOPE Primary Key

Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_3710 INDEXTYPE+INDEXSCOPE SRCHCONFEXT INDEXTYPE+INDEXSCOPE Cascade

Name	Type	Description
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.
LANGUAGES	VARCHAR (1600) NOT NULL	The languages that the data is indexed in.
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.