WebSphere Commerce database table: PESTATS

This table captures statistics related to the Product Explorer Product Advisor metaphor.


Column Description(s):
Column NameColumn TypeDescription
STOREENT_ID INTEGER NOT NULL The store entity identifier as described in the STOREENT_ID column of the STOREENT table.
CATGROUP_ID BIGINT NOT NULL The category group identifier as described in the CATGROUP_ID column of the CATGROUP table.
FEATURE_ID INTEGER NOT NULL This is the feature identifier as described in the FEATUREID column of the ICEXPLFEAT table.
FEATURENAME VARCHAR(64) This is the feature name as described in the NAME column of the ICEXPLDESC table.
COUNT INTEGER The total number of times this a feature was searched for in Product Explorer.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031254650 STOREENT_ID+CATGROUP_ID+FEATURE_ID Primary Key

Feedback