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 |
---|---|---|---|---|
| smallint | No | Identifier; primary key. | |
| varchar | 254 | No | Name of language in default language. |
| varchar | 254 | Yes | Name of language in English. |
| char | 2 | Yes | ISO 639-1 two-letter alphabetic code for the language. |
| char | 3 | No | ISO 639-1 three-letter alphabetic code for the language. |
| timestamp | Yes | Date when the information in this warehouse record became effective. | |
| timestamp | Yes | Date when the information in this warehouse record is no longer effective. |