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 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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031232080 |
FEATUREID+METAPHORID |
Primary Key |
I0000123 |
STOREID |
Non-Unique Index |
I0000124 |
ORDERSEQ |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign 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 Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_362 |
FEATUREID METAPHORID |
ICFEATPROP |
FEATUREID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.