This table lists and briefly describes all the metaphors.
Column Description(s):
Column Name | Column Type | Description |
METAPHORID |
INTEGER NOT NULL |
The internal reference number of the metaphor. |
CATEGORYID |
BIGINT NOT NULL |
The internal reference number of the CatalogGroup for which this metaphor is created. |
STOREID |
INTEGER NOT NULL |
The internal reference number of the store to which this metaphor belongs. |
TREEID |
INTEGER |
The internal reference number of the Question and Answer tree if this is a Guided Sell metaphor. |
EXPLREQ |
INTEGER |
Indicates whether or not exploration space is required. This is not used for the Guided Sell 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. |
SYNC |
INTEGER NOT NULL DEFAULT 1 |
Reserved for IBM internal use. |
TEMPLATENAME |
VARCHAR(254) |
JSP page filename for this metaphor. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000125 |
METAPHORNAME+CATEGORYID+STOREID |
Unique Index |
SQL050212031232230 |
METAPHORID |
Primary Key |
I0000127 |
STOREID |
Non-Unique Index |
I0000580 |
CATEGORYID |
Non-Unique Index |
I0000581 |
TREEID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_972 |
TREEID |
ICMERTREE |
TREEID |
Cascade |
F_372 |
CATEGORYID |
ICROOTCAT |
ROOTCATEGORYID |
Cascade |
F_947 |
STOREID |
STORE |
STORE_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.