SRCHATTR

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


Column Descriptions:

Name Type Description
SRCHATTR_ID BIGINT NOT NULL Generated Primary Key
INDEXSCOPE VARCHAR (128) The scope of the indexed data. For example, master catalog.
INDEXTYPE VARCHAR (128) The type of search index. For example, Catentry.
IDENTIFIER VARCHAR (254) NOT NULL The logical identifier of the attribute.
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> SRCHATTR_ID Primary Key
I0001403 INDEXSCOPE+INDEXTYPE+IDENTIFIER Unique Index
I0001474 INDEXTYPE Non-Unique Index


Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_3689 SRCHATTR_ID SRCHATTRPROP SRCHATTR_ID Cascade
F_3733 SRCHATTR_ID FACET SRCHATTR_ID Cascade
F_3744 SRCHATTR_ID SRCHATTRDESC SRCHATTR_ID Cascade