ATTRDICTSRCHCONF

The mapping table between attribute dictionary attribute's identifiers and fields in search schema.

Column Descriptions:

Name	Type	Description
ATTRDICTSRCHCNF_ID	BIGINT NOT NULL	The ATTRDICTSRCHCNF ID.
MASTERCATALOG_ID	BIGINT NOT NULL	The master catalog of the attribute.
SRCHFIELDNAME	VARCHAR (18) NOT NULL	The field name of the search schema.
ATTR_ID	BIGINT	The attribute's ID.
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>	ATTRDICTSRCHCNF_ID	Primary Key
I0001471	ATTR_ID	Non-Unique Index
I0001472	ATTRTYPE_ID	Non-Unique Index
I0001473	MASTERCATALOG_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3679	MASTERCATALOG_ID	CATALOG	CATALOG_ID	Cascade
F_3680	ATTR_ID	ATTR	ATTR_ID	Cascade
F_3681	ATTRTYPE_ID	ATTRTYPE	ATTRTYPE_ID	Cascade