Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICMETAPHOR
This table is deprecated and is provided for backward compatibility only. This table lists and briefly describes all the metaphors.
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.
Indexes Index Name Indexed Column Names Index Type I0000125 METAPHORNAME+CATEGORYID+STOREID Unique Index SQL100520030343520 METAPHORID Primary Key I0000127 STOREID Non-Unique Index I0000580 CATEGORYID Non-Unique Index I0000581 TREEID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 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
Related reference
_vcc_freeselect_bottom_