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 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.
Indexes:
Index Name Indexed Column Names Index Type
I0000118 CATGROUP_ID, COLUMNNAME Unique Index
I0000119 COLUMNNAME Non-Unique Index
SQL030416034940260 FEATUREID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_361 CATGROUP_ID CATGROUP CATGROUP_ID Cascade

Referenced By:
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