This table stores search relevancy values for a
search field
Column Descriptions:
| Name | Type | Description |
| SRCHPROPRELV_ID | BIGINT NOT NULL | The primary Key of the category, indexfield
relationship table. |
| CATALOG_ID | BIGINT NOT NULL | The catalog ID. |
| STOREENT_ID | INTEGER NOT NULL | The store entity ID. |
| CATGROUP_ID | BIGINT NOT NULL DEFAULT 0 | The category ID (Catalog group). The default
value of 0 denotes all catalog groups. |
| RELVALUE | DOUBLE NOT NULL DEFAULT 0 | The relevancy value used in search. The value is
a decimal. For example, categoryname has a value of 100.0 by
default. |
| INDEXFIELD | VARCHAR (128) | The search index field name. That is, the Solr
index field name that represents a catalog entry property. |
| 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 |
| P_0027 | SRCHPROPRELV_ID | Primary Key |
| I0001498 | INDEXFIELD+CATGROUP_ID+STOREENT_ID+CATALOG_ID | Unique Index |
| I0001499 | CATALOG_ID | Non-Unique Index |
| I0001503 | STOREENT_ID | Non-Unique Index |
| I0001504 | CATGROUP_ID+STOREENT_ID+CATALOG_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3762 | CATALOG_ID | CATALOG | CATALOG_ID | Cascade |
| F_3763 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
| F_3764 | CATGROUP_ID | CATGROUP | CATGROUP_ID | Cascade |