SRCHATTR

Each row represents the logical name of a catalog attribute that is defined in the search schema.

Column Descriptions:

NameTypeDescription
SRCHATTR_IDBIGINT NOT NULLGenerated Primary Key
INDEXSCOPEVARCHAR (128)The scope of the indexed data. For example, master catalog.
INDEXTYPEVARCHAR (128)The type of search index. For example, Catentry.
IDENTIFIERVARCHAR (254) NOT NULLThe logical identifier of the attribute.
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>SRCHATTR_IDPrimary Key
I0001403INDEXSCOPE+INDEXTYPE+IDENTIFIERUnique Index
I0001474INDEXTYPENon-Unique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3689SRCHATTR_IDSRCHATTRPROPSRCHATTR_IDCascade
F_3733SRCHATTR_IDFACETSRCHATTR_IDCascade
F_3744SRCHATTR_IDSRCHATTRDESCSRCHATTR_IDCascade