ATTRDICTSRCHCONF

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

Column Descriptions:

NameTypeDescription
ATTRDICTSRCHCNF_IDBIGINT NOT NULLThe ATTRDICTSRCHCNF ID.
MASTERCATALOG_IDBIGINT NOT NULLThe master catalog of the attribute.
SRCHFIELDNAMEVARCHAR (18) NOT NULLThe field name of the search schema.
ATTR_IDBIGINTThe attribute's ID.
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>ATTRDICTSRCHCNF_IDPrimary Key
I0001471ATTR_IDNon-Unique Index
I0001472ATTRTYPE_IDNon-Unique Index
I0001473MASTERCATALOG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3679MASTERCATALOG_IDCATALOGCATALOG_IDCascade
F_3680ATTR_IDATTRATTR_IDCascade
F_3681ATTRTYPE_IDATTRTYPEATTRTYPE_IDCascade