WebSphere Commerce database table: ICMERTREE

This table contains the store and its associated Guided Sell metaphors.


Column Description(s):
Column NameColumn TypeDescription
STOREID INTEGER NOT NULL Internal reference number for the store.
TREEID INTEGER NOT NULL The internal reference number of the Question and Answer tree.
METAPHORID INTEGER NOT NULL A Guided Sell metaphor created for the store. Foreign key to the ICMETAPHOR table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000122 METAPHORID Unique Index
SQL050212031231950 TREEID Primary Key
I0000579 STOREID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_369 METAPHORID ICMETAPHOR METAPHORID Cascade
F_970 STOREID STORE STORE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_365 TREEID ICKNOWLEDG TREEID Cascade
F_368 TREEID ICMERDESC TREEID Cascade
F_972 TREEID ICMETAPHOR TREEID Cascade

Feedback