Database Table: ICMERTREE

This table stores the store and its associated Sales Assistant metaphors.

Column Name Column Type Column Description
METAPHORID INTEGER
NOT NULL
A sales assistant metaphor created for the store. Foreign key to the ICMETAPHOR table.
STOREID INTEGER
NOT NULL
Internal reference number for the store.
TREEID INTEGER
NOT NULL
The internal reference number of the Question and Answer tree.
Indexes:
Index Name Indexed Column Names Index Type
I0000122 METAPHORID Unique Index
SQL030416034942040 TREEID Primary Key
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