The configuration table extended for SRCHCONF for
HCL 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 |