CLSATTRSRCHCONF

The mapping table between classic attribute's name and fields in search schema.

Column Descriptions:

Name	Type	Description
CLSATTRSRCHCONF_ID	BIGINT NOT NULL	The CLSATTRSRCHCONF ID.
MASTERCATALOG_ID	BIGINT NOT NULL	The master catalog of the attribute.
SRCHFIELDNAME	VARCHAR (18) NOT NULL	The field name of the search schema.
ATTRNAME	VARCHAR (254)	The name of the attribute.
LANGUAGE_ID	INTEGER	The language ID of the attribute's name.
ATTRTYPE_ID	CHAR (16) NOT NULL	The type of the attribute.
TEMPTABLEPFIX	VARCHAR (14) NOT NULL	The prefix of the temporary table's name for index building.
SEPARATOR	VARCHAR (4)	The separator character to separate multiple values.
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>	CLSATTRSRCHCONF_ID	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3682	MASTERCATALOG_ID	CATALOG	CATALOG_ID	Cascade
F_3683	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_3684	ATTRTYPE_ID	ATTRTYPE	ATTRTYPE_ID	Cascade