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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000117 | NAME | Non-Unique Index |
SQL030416034939950 | FEATUREID, LANGUAGE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|