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, index field
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, the category name 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 |