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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000123 | STOREID | Non-Unique Index |
I0000124 | ORDERSEQ | Non-Unique Index |
SQL030416034942380 | FEATUREID, METAPHORID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_362 | FEATUREID+METAPHORID | ICFEATPROP | FEATUREID+METAPHORID | Cascade |