Database Table: ICMETAPHOR

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000125 METAPHORNAME, CATEGORYID, STOREID Unique Index
I0000127 STOREID Non-Unique Index
SQL030416034942790 METAPHORID Primary Key
Constraints:
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

Referenced By:
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