Database Table: ICMETAFEAT

This table identifies which features are used by the Product Exploration and Product Comparison metaphors and the sequence that they will be displayed.

Column Name Column Type Column Description
DISPLAYABLE INTEGER
NOT NULL
Determines whether this feature will be displayed or not. Valid values:
0 = do not display this feature (attribute) in this metaphor.
1 = display this feature (attribute) in this metaphor.
FEATUREID INTEGER
NOT NULL
The internal reference number of the feature. Foreign key to the ICEXPLFEAT table.
METAPHORID INTEGER
NOT NULL
The internal reference number of the metaphor that this feature setting belongs to. Foreign key to ICMETAPHOR table.
ORDERSEQ INTEGER
NOT NULL
The order sequence of the features when displayed.
STOREID INTEGER
NOT NULL
The internal reference number of the store that this feature setting belongs to.
Indexes:
Index Name Indexed Column Names Index Type
I0000123 STOREID Non-Unique Index
I0000124 ORDERSEQ Non-Unique Index
SQL030416034942380 FEATUREID, METAPHORID Primary Key
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+METAPHORID Cascade