WebSphere Commerce database table: PCSTATS

WebSphere Commerce database table: PCSTATS

This table captures statistics related to the Product Comparison Product Advisor metaphor.
Column Descriptions
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.
VIEWS INTEGER The total number of products shown to customers in Product Comparison.
CLICKS INTEGER The number of times customers clicked on a product in Product Comparison.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235228220 STOREENT_ID+CATGROUP_ID Primary Key

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.
VIEWS	INTEGER	The total number of products shown to customers in Product Comparison.
CLICKS	INTEGER	The number of times customers clicked on a product in Product Comparison.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.