Database Table: ICEXPLDESC

This table stores the language-dependent values for the feature metadata.

Column Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NULL
Feature name used in JSP file for display.
ELABORATION VARCHAR (254)
NULL
Reserved for IBM internal use.
FEATUREID INTEGER
NOT NULL
The internal reference number of the feature. Foreign key to the ICEXPLFEAT table.
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.
NAME VARCHAR (254)
NOT NULL
Feature name. Out of the box features come from the CATENTRY, CATENTDESC tables. User defined features come from the ATTRIBUTE, CATENTATTR, and PKGATTR tables.
PRECISION INTEGER
NULL
Precision used for displaying values. For example, Price.
SCALE INTEGER
NULL
Scale used for displaying values. For example, Price.
UNITOFMEASURE VARCHAR (20)
NULL
Unit of measure to display alongside values. For example, lbs or inches.
Indexes:
Index Name Indexed Column Names Index Type
I0000117 NAME Non-Unique Index
SQL030416034939950 FEATUREID, LANGUAGE_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable