This table describes the properties of the metaphors. This table is only used by the Guided Sell metaphor.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031232360 |
METAPHORID+PROPERTYNAME |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_373 |
METAPHORID |
ICMETAPHOR |
METAPHORID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.