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 Descriptions
| 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.
|