Database Table: PASTATS

This table captures the invocation statistics for each 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 number of times this particular metaphor was invoked by a customer.
METAPHORTYPE INTEGER
NOT NULL
The metaphor type identifier as described in the METAPHORTYPEID column of the ICMETAREG 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
SQL030416035027560 STOREENT_ID, CATGROUP_ID, METAPHORTYPE 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