Database Table: ICFEATPROP

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000331 METAPHORID, FEATUREID Non-Unique Index
SQL030416034940620 FEATUREID, METAPHORID, PROPERTYNAME Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_362 FEATUREID, METAPHORID ICMETAFEAT FEATUREID, METAPHORID Cascade

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