SRCHPROPRELV

This table stores search relevancy values for a search field

Column Descriptions:

NameTypeDescription
SRCHPROPRELV_IDBIGINT NOT NULLThe primary Key of the category, indexfield relationship table.
CATALOG_IDBIGINT NOT NULLThe catalog ID.
STOREENT_IDINTEGER NOT NULLThe store entity ID.
CATGROUP_IDBIGINT NOT NULL DEFAULT 0The category ID (Catalog group). The default value of 0 denotes all catalog groups.
RELVALUEDOUBLE NOT NULL DEFAULT 0The relevancy value used in search. The value is a decimal. For example, categoryname has a value of 100.0 by default.
INDEXFIELDVARCHAR (128)The search index field name. That is, the Solr index field name that represents a catalog entry property.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0027SRCHPROPRELV_IDPrimary Key
I0001498INDEXFIELD+CATGROUP_ID+STOREENT_ID+CATALOG_IDUnique Index
I0001499CATALOG_IDNon-Unique Index
I0001503STOREENT_IDNon-Unique Index
I0001504CATGROUP_ID+STOREENT_ID+CATALOG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3762CATALOG_IDCATALOGCATALOG_IDCascade
F_3763STOREENT_IDSTOREENTSTOREENT_IDCascade
F_3764CATGROUP_IDCATGROUPCATGROUP_IDCascade