Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICEXPLDESC
This table is deprecated and is provided for backward compatibility only. This table stores the language-dependent values for the feature metadata.
Column Name Column Type Description FEATUREID INTEGER NOT NULL The internal reference number of the feature. Foreign key to the ICEXPLFEAT table. NAME VARCHAR(254) NOT NULL Feature name. By default, features come from the CATENTRY and CATENTDESC tables. User-defined features come from the ATTRIBUTE, CATENTATTR, and PKGATTR tables. UNITOFMEASURE VARCHAR(20) Unit of measure to display alongside values. For example, lbs or inches. DESCRIPTION VARCHAR(254) Feature name used in the JSP page for display. ELABORATION VARCHAR(254) Reserved for IBM internal use. SCALE INTEGER Scale used for displaying values. For example, price. PRECISION INTEGER Precision used for displaying values. For example, price. LANGUAGE_ID INTEGER NOT NULL The unique identifier of the language. Foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030342130 FEATUREID+LANGUAGE_ID Primary Key I0000117 NAME Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_359 FEATUREID ICEXPLFEAT FEATUREID Cascade F_360 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference
_vcc_freeselect_bottom_