SRCHPROPRELV

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