Reference > Database > WebSphere Commerce database tables > I


WebSphere Commerce database table: ICMETAFEAT

This table is deprecated and is provided for backward compatibility only. This table identifies the features used by the Product Exploration and Product Comparison metaphors and the sequence in which the features display.

Column Name Column Type Description
FEATUREID INTEGER NOT NULL The internal reference number of the feature. Foreign key to the ICEXPLFEAT table.
STOREID INTEGER NOT NULL The internal reference number of the store to which this feature setting belongs.
METAPHORID INTEGER NOT NULL The internal reference number of the metaphor to which this feature setting belongs. Foreign key to ICMETAPHOR table.
DISPLAYABLE INTEGER NOT NULL Determines whether or not this feature will display. Valid values:
0 = do not display this feature (attribute) in this metaphor.
1 = display this feature (attribute) in this metaphor.
ORDERSEQ INTEGER NOT NULL The sequence in which the features display.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030343360 FEATUREID+METAPHORID Primary Key
I0000123 STOREID Non-Unique Index
I0000124 ORDERSEQ Non-Unique Index
I0001259 METAPHORID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_370 FEATUREID ICEXPLFEAT FEATUREID Cascade
F_371 METAPHORID ICMETAPHOR METAPHORID Cascade
F_946 STOREID STORE STORE_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_362 FEATUREID METAPHORID ICFEATPROP FEATUREID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search