WebSphere Commerce database table: ICMETAPROP

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031232360 METAPHORID+PROPERTYNAME Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_373 METAPHORID ICMETAPHOR METAPHORID Cascade

Feedback