Database Table: SASTATS

This table captures statistics related to the Sales Assistant Product Advisor metaphor.

Column Name Column Type Column Description
CATGROUP_ID BIGINT
NULL
The category group identifier as described in the CATGROUP_ID column of the CATGROUP table.
CONCEPT_ID INTEGER
NOT NULL
This is the concept identifier as described in the CONCEPTID column of the ICKNOWLEDG table.
COUNT INTEGER
NULL
The number of times the particular concept or tree or store was selected (answered) by the customer.
STOREENT_ID INTEGER
NOT NULL
The store entity identifier as described in the STOREENT_ID column of the STOREENT table.
TREE_ID INTEGER
NOT NULL
The tree identifier as described in the TREEID column of the ICKNOWLEDG table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035100450 STOREENT_ID, TREE_ID, CONCEPT_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