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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034943090 | METAPHORID, PROPERTYNAME | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_373 | METAPHORID | ICMETAPHOR | METAPHORID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|