This table lists the country or region names in each of the supported languages identified by LANGUAGE_ID. (Note that some of the entries may store the region name rather than the official country name in the NAME column for historical reasons.)
Column Name | Column Type | Column Description |
---|---|---|
COUNTRYABBR | CHARACTER (5) NOT NULL |
Country or region abbreviation code. This code is derived from the ISO-3166 Alpha-2 codes. For countries or regions with multiple commonly used names a number or letter may be appended to the ISO-3166 alpha-2 code to form the abbreviation code. |
LANGUAGE_ID | INTEGER NOT NULL |
The language of the value in the NAME column. For a list of language components, see the LANGUAGE table. |
NAME | VARCHAR (254) NULL |
Name of the country or region in the language identified by LANGUAGE_ID. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000342 | LANGUAGE_ID, NAME | Non-Unique Index |
I0000343 | NAME | Non-Unique Index |
SQL030416034913090 | COUNTRYABBR, LANGUAGE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_257 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|