This table holds a list of languages that can be referenced by other tables. It uses the ISO 639-1 and 639-2 codes.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | smallint | No | Identifier; primary key. | |
LANG_NAME | varchar | 254 | No | Name of language in default language. |
LANG_NAME_EN | varchar | 254 | Yes | Name of language in English. |
ISO_639_1_ALPHA2 | char | 2 | Yes | ISO 639-1 two-letter alphabetic code for the language. |
ISO_639_2_ALPHA3 | char | 3 | No | ISO 639-1 three-letter alphabetic code for the language. |
RECORD_START_DATE | timestamp | Yes | Date when the information in this warehouse record became effective. | |
RECORD_END_DATE | timestamp | Yes | Date when the information in this warehouse record is no longer effective. |