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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000122 | METAPHORID | Unique Index |
SQL030416034942040 | TREEID | Primary Key |
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 |