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 Name | Column Type | Column Description |
---|---|---|
CATGROUP_ID | BIGINT NOT NULL |
The internal reference number of the Catalog Group. Foreign key to the CATGROUP table. |
COLUMNNAME | VARCHAR (254) NOT NULL |
Name of the column containing values for this feature in the search space (ICT<catgroup_id===ICEXPLFEAT===COLUMNNAME===gt;tables). |
DATATYPE | CHARACTER (100) NULL |
Data type of the feature. All available data types are in ICDATAREG. |
FEATUREID | INTEGER NOT NULL |
The internal reference number of the feature. |
INCLUDED | INTEGER NOT NULL, DEFAULT 1 |
Whether this feature is available for use in the metaphors. Valid values: 0=No, 1=Yes. |
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. |
LENGTH | INTEGER NOT NULL, DEFAULT 0 |
Maximum length of the values for this feature. |
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. |
NULLABLE | INTEGER NOT NULL, DEFAULT 1 |
Whether the column for this feature can contain null values. Valid values: 0=not nullable, 1=nullable. |
RELEVANCE | INTEGER NOT NULL, DEFAULT 1 |
Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000118 | CATGROUP_ID, COLUMNNAME | Unique Index |
I0000119 | COLUMNNAME | Non-Unique Index |
SQL030416034940260 | FEATUREID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_361 | CATGROUP_ID | CATGROUP | CATGROUP_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_356 | FEATUREID | ICCONSTRNT | FEATUREID | Cascade |
F_359 | FEATUREID | ICEXPLDESC | FEATUREID | Cascade |
F_370 | FEATUREID | ICMETAFEAT | FEATUREID | Cascade |