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 |