Database Table: ICMETAPROP

This table describes the properties of the metaphors. Currently this is only used by Sales Assistant Metaphor.

Column Name Column Type Column 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 Sales Assistant.)
PROPERTYTYPE INTEGER
NOT NULL
Type of the property: 0=String, 1=Integer, 2=Long, 3=Float, 4=Double, or 5=Boolean.
PROPERTYVALUE VARCHAR (254)
NOT NULL
Value for the property.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034943090 METAPHORID, PROPERTYNAME Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_373 METAPHORID ICMETAPHOR METAPHORID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable