This table stores the properties that are defined
for each search index attribute. For example, the properties are
rank, sort, catalogFilter, display, facet, filter and search.
Column Descriptions:
| Name | Type | Description |
| SRCHATTR_ID | BIGINT NOT NULL | Foreign key to the SrchAttr table. |
| PROPERTYNAME | VARCHAR (254) NOT NULL | The name of the property. For example rank or
sort. |
| PROPERTYVALUE | VARCHAR (254) | The value for the particular search attribute and
property. For example, the search index name. |
| 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+PROPERTYNAME | Primary Key |
| I0001475 | PROPERTYNAME+PROPERTYVALUE | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3689 | SRCHATTR_ID | SRCHATTR | SRCHATTR_ID | Cascade |