WebSphere Commerce database table: ICMETAPROP

This table describes the properties of the metaphors. This table is only used by the Guided Sell metaphor.

Column Descriptions
Column Name Column Type Description
METAPHORID INTEGER NOT NULL The internal reference number for the metaphor. Foreign key to the ICMETAPHOR table.
PROPERTYNAME VARCHAR(64) NOT NULL Property of a metaphor that can be set. For example, DEFAULT_METAPHOR_NAME, DEFAULT_METAPHOR_CATEGORY_ID for Guided Sell.
PROPERTYTYPE INTEGER NOT NULL A number that represents the type of the property: 0=String, 1=Integer, 2=Long, 3=Float, 4=Double, or 5=Boolean.
PROPERTYVALUE VARCHAR(254) NOT NULL The value of the property.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235206330 METAPHORID+PROPERTYNAME Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_373 METAPHORID ICMETAPHOR METAPHORID Cascade
Related reference