Database Table: PCSTATS

This table captures statistics related to the Product Comparison 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.
CLICKS INTEGER
NULL
The number of times customers clicked on a product in Product Comparison.
STOREENT_ID INTEGER
NOT NULL
The store entity identifier as described in the STOREENT_ID column of the STOREENT table.
VIEWS INTEGER
NULL
The total number of products shown to customers in Product Comparison.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035031300 STOREENT_ID, CATGROUP_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