Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PCSTATS
This table captures statistics related to the Product Comparison Product Advisor metaphor.
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 SQL100520030408920 STOREENT_ID+CATGROUP_ID Primary Key _vcc_freeselect_bottom_