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