This table stores the metadata for features extracted from WebSphere Commerce tables. The data in this table is unique to a feature, but independent of stores and languages.
Column Description(s):
Column Name | Column Type | Description |
FEATUREID |
INTEGER NOT NULL |
The internal reference number of the feature. |
COLUMNNAME |
VARCHAR(254) NOT NULL |
Name of the column containing values for this feature in the search space (ICT<catgroup_id>tables). |
LENGTH |
INTEGER NOT NULL DEFAULT 0 |
Maximum length of the values for this feature. |
DATATYPE |
CHAR(100) |
Data type of the feature. All available data types are in ICDATAREG. |
KEYSEQUENCE |
INTEGER NOT NULL DEFAULT 0 |
Mark a column as a primary key column. Valid values: 0=not part of primary key 1=part of primary key. |
NULLABLE |
INTEGER NOT NULL DEFAULT 1 |
Whether the column for this feature can contain null values. Valid values: 0=not nullable, 1=nullable. |
LOCATION |
INTEGER NOT NULL DEFAULT 2 |
Which base table this feature comes from. Valid values: 0=CATENTRY, 1=ATTRIBUTE, 2=LISTPRICE, 3=CATENTDESC, 4=CATENTATTR, or 5=PKGATTR. |
INCLUDED |
INTEGER NOT NULL DEFAULT 1 |
Whether this feature is available for use in the metaphors. Valid values: 0=No, 1=Yes. |
RELEVANCE |
INTEGER NOT NULL DEFAULT 1 |
Reserved for IBM internal use. |
CATGROUP_ID |
BIGINT NOT NULL |
The internal reference number of the Catalog Group. Foreign key to the CATGROUP table. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000118 |
CATGROUP_ID+COLUMNNAME |
Unique Index |
SQL050212031231240 |
FEATUREID |
Primary Key |
I0000119 |
COLUMNNAME |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_361 |
CATGROUP_ID |
CATGROUP |
CATGROUP_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_356 |
FEATUREID |
ICCONSTRNT |
FEATUREID |
Cascade |
F_359 |
FEATUREID |
ICEXPLDESC |
FEATUREID |
Cascade |
F_370 |
FEATUREID |
ICMETAFEAT |
FEATUREID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.