Reference > Database > WebSphere Commerce database tables > C
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 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. CALLINGCODE VARCHAR(16) No CALLINGCODE external description assigned yet OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030319640 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
_vcc_freeselect_bottom_