Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICEXPLFEAT
This table is deprecated and is provided for backward compatibility only. 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 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.
Indexes Index Name Indexed Column Names Index Type I0000118 CATGROUP_ID+COLUMNNAME Unique Index SQL100520030342300 FEATUREID Primary Key I0000119 COLUMNNAME Non-Unique Index
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
Related reference
_vcc_freeselect_bottom_