WebSphere Commerce database table: ICMETAFEAT

This table identifies the features used by the Product Exploration and Product Comparison metaphors and the sequence in which the features display.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031232080 FEATUREID+METAPHORID Primary Key
I0000123 STOREID Non-Unique Index
I0000124 ORDERSEQ Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_370 FEATUREID ICEXPLFEAT FEATUREID Cascade
F_371 METAPHORID ICMETAPHOR METAPHORID Cascade
F_946 STOREID STORE STORE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_362 FEATUREID METAPHORID ICFEATPROP FEATUREID Cascade

Feedback