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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031216480 COUNTRYABBR+LANGUAGE_ID Primary Key
I0000342 LANGUAGE_ID+NAME Non-Unique Index
I0000343 NAME Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_257 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback