WebSphere Commerce database table: ICMERTREE

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

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
I0000122 METAPHORID Unique Index
SQL060903235205760 TREEID Primary Key
I0000579 STOREID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_369 METAPHORID ICMETAPHOR METAPHORID Cascade
F_970 STOREID STORE STORE_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_365 TREEID ICKNOWLEDG TREEID Cascade
F_368 TREEID ICMERDESC TREEID Cascade
F_972 TREEID ICMETAPHOR TREEID Cascade
Related reference