Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICFEATPROP
This table is deprecated and is provided for backward compatibility only. This table describes the properties of the features, which the Product Exploration and Product Comparison metaphors use.
Column Name Column Type 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 and the 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. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030342450 FEATUREID+METAPHORID+PROPERTYNAME Primary Key I0000331 METAPHORID+FEATUREID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_362 FEATUREID METAPHORID ICMETAFEAT FEATUREID Cascade
Related reference
_vcc_freeselect_bottom_