WebSphere Commerce database table: COUNTRY
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 Descriptions
| Column Name
| Column Type
| Description |
| COUNTRYABBR
| CHAR(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)
| Name of the country or region in the language identified by LANGUAGE_ID.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235145940
| COUNTRYABBR+LANGUAGE_ID
| Primary Key
|
| I0000342
| LANGUAGE_ID+NAME
| Non-Unique Index
|
| I0000343
| NAME
| Non-Unique Index
|
Constraints
| Constraint Name
| Column Names
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_257
| LANGUAGE_ID
| LANGUAGE
| LANGUAGE_ID
| Cascade
|
Related reference