The table `itgen_languages` holds: languages supported. Example: 'en'. It keeps history. Its natural key code is `lge`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `code` (`varchar2(30)`, required): Code. ISO 639-2 coded language name. - `description` (`varchar2(240)`, required): Description. Description of the language. - `documentation` (`varchar2(4000)`): Documentation. Documentation on the language. - `oracle_nls_date_format` (`varchar2(240)`, required): Database NLS Date Format. Setting for the NLS_DATE_FORMAT variable of Oracle when using this language. - `oracle_nls_date_s_format` (`varchar2(240)`, required): Oracle NLS Date Short Format. Short date format, excluding time. - `oracle_nls_date_t_format` (`varchar2(240)`, required): Oracle NLS Date Time Format. Time format. - `oracle_nls_language` (`varchar2(240)`, required): Database NLS Language. Setting for the NLS_LANGUAGE variable of Oracle when using this language. - `oracle_nls_numeric_chars` (`varchar2(240)`, required): Oracle NLS Numeric Characters. Setting for the NLS_NUMERIC_CHARACTERS variable of Oracle when using this language. - `oracle_nls_territory` (`varchar2(240)`, required): Database NLS Territory. Setting for the NLS_TERRITORY variable of Oracle when using this language. - `oracle_nls_date_ts_format` (`varchar2(240)`, required): Oracle NLS Short Time Format. Time format without seconds. - `column1` to `column10` and `column_type`: free text columns to extend the data model with fields only available at one site. ## Referential Constraints The table is related to other tables as follows: - Application Languages refers to this table through `lge_id`. - Applications refers to this table through `lge_id`. - Glossaries refers to this table through `lge_id`. - Settings refers to this table through `lge_id`. ## Indexes The table has these indexes: - `itgen_lge_n2` on `id`, `code`. - `itgen_lge_nk` (unique) on `code`. - `itgen_lge_pk` (unique) on `id`. - `itgen_lge_uk_orig` (unique) on `orig_system_reference`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].