This table describes the properties of the features used by the Product Exploration and Product Comparison metaphors.
Column Name | Column Type | Column Description |
---|---|---|
FEATUREID | INTEGER NOT NULL |
The internal reference number of the feature. This column and METAPHORID form a foreign key to the ICMETAFEAT table. |
METAPHORID | INTEGER NOT NULL |
The internal reference number of the metaphor. This column and FEATUREID form a foreign key to the ICMETAFEAT table. |
PROPERTYNAME | VARCHAR (64) NOT NULL |
Property of a feature that can be set. For example, sort order, widget type for Product Exploration, and product link for Product Comparison. |
PROPERTYTYPE | INTEGER NOT NULL |
Type of the property. Valid values: 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 |
---|---|---|
I0000331 | METAPHORID, FEATUREID | Non-Unique Index |
SQL030416034940620 | FEATUREID, METAPHORID, PROPERTYNAME | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_362 | FEATUREID, METAPHORID | ICMETAFEAT | FEATUREID, METAPHORID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|