This table captures statistics related to the Product Explorer Product Advisor metaphor.
Column Description(s):
Column Name | Column Type | Description |
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 Name | Indexed Column Names | Index Type |
SQL050212031254650 |
STOREENT_ID+CATGROUP_ID+FEATURE_ID |
Primary Key |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.