WebSphere Commerce database table: SASTATS

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


Column Description(s):
Column NameColumn TypeDescription
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.
CONCEPT_ID INTEGER NOT NULL This is the concept identifier as described in the CONCEPTID column of the ICKNOWLEDG table.
CATGROUP_ID BIGINT The category group identifier as described in the CATGROUP_ID column of the CATGROUP table.
COUNT INTEGER The number of times the particular concept or tree or store was selected (answered) by the customer.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031309390 STOREENT_ID+TREE_ID+CONCEPT_ID Primary Key

Feedback