CLSATTRSRCHCONF

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

Column Descriptions:

NameTypeDescription
CLSATTRSRCHCONF_IDBIGINT NOT NULLThe CLSATTRSRCHCONF ID.
MASTERCATALOG_IDBIGINT NOT NULLThe master catalog of the attribute.
SRCHFIELDNAMEVARCHAR (18) NOT NULLThe field name of the search schema.
ATTRNAMEVARCHAR (254)The name of the attribute.
LANGUAGE_IDINTEGERThe language ID of the attribute's name.
ATTRTYPE_IDCHAR (16) NOT NULLThe type of the attribute.
TEMPTABLEPFIXVARCHAR (14) NOT NULLThe prefix of the temporary table's name for index building.
SEPARATORVARCHAR (4)The separator character to separate multiple values.
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>CLSATTRSRCHCONF_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3682MASTERCATALOG_IDCATALOGCATALOG_IDCascade
F_3683LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_3684ATTRTYPE_IDATTRTYPEATTRTYPE_IDCascade