Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICMERTREE
This table is deprecated and is provided for backward compatibility only. This table contains the store and its associated Guided Sell metaphors.
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 SQL100520030343070 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
Referenced By 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
_vcc_freeselect_bottom_