Database Table: PESTATS

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

Column Name Column Type Column Description
CATGROUP_ID BIGINT
NOT NULL
The category group identifier as described in the CATGROUP_ID column of the CATGROUP table.
COUNT INTEGER
NULL
The total number of times this a feature was searched for in Product Explorer.
FEATURENAME VARCHAR (64)
NULL
This is the feature name as described in the NAME column of the ICEXPLDESC table.
FEATURE_ID INTEGER
NOT NULL
This is the feature identifier as described in the FEATUREID column of the ICEXPLFEAT table.
STOREENT_ID INTEGER
NOT NULL
The store entity identifier as described in the STOREENT_ID column of the STOREENT table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035031760 STOREENT_ID, CATGROUP_ID, FEATURE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable