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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035100450 | STOREENT_ID, TREE_ID, CONCEPT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|