This table lists and briefly describes all the metaphors.
Column Name | Column Type | Column Description |
---|---|---|
CATEGORYID | BIGINT NOT NULL |
The internal reference number of the CatalogGroup that this metaphor is created for. |
EXPLREQ | INTEGER NULL |
Is exploration space required or not? This is not used for Sales Assistant Metaphor. |
METAPHORID | INTEGER NOT NULL |
The internal reference number of the metaphor. |
METAPHORNAME | VARCHAR (128) NOT NULL |
Java class name of the metaphor. For example, com.ibm.commerce.pa.metaphor.ProductExplorerMetaphor. |
PUBLISH | INTEGER NOT NULL, DEFAULT 0 |
Reserved for IBM internal use. |
STOREID | INTEGER NOT NULL |
The internal reference number of the store that this metaphor belongs to. |
SYNC | INTEGER NOT NULL, DEFAULT 1 |
Reserved for IBM internal use. |
TEMPLATENAME | VARCHAR (254) NULL |
JSP filename for this metaphor. |
TREEID | INTEGER NULL |
The internal reference number of the Question and Answer tree if this is a Sales Assistant Metaphor. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000125 | METAPHORNAME, CATEGORYID, STOREID | Unique Index |
I0000127 | STOREID | Non-Unique Index |
SQL030416034942790 | METAPHORID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_372 | CATEGORYID | ICROOTCAT | ROOTCATEGORYID | Cascade |
F_947 | STOREID | STORE | STORE_ID | Cascade |
F_972 | TREEID | ICMERTREE | TREEID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_353 | METAPHORID | ICCNCPTLNK | METAPHORID | Cascade |
F_369 | METAPHORID | ICMERTREE | METAPHORID | Cascade |
F_371 | METAPHORID | ICMETAFEAT | METAPHORID | Cascade |
F_373 | METAPHORID | ICMETAPROP | METAPHORID | Cascade |