WebSphere Commerce database table: ICEXPLFEAT

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 NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I0000118 CATGROUP_ID+COLUMNNAME Unique Index
SQL050212031231240 FEATUREID Primary Key
I0000119 COLUMNNAME Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_361 CATGROUP_ID CATGROUP CATGROUP_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_356 FEATUREID ICCONSTRNT FEATUREID Cascade
F_359 FEATUREID ICEXPLDESC FEATUREID Cascade
F_370 FEATUREID ICMETAFEAT FEATUREID Cascade

Feedback