COUNTCODE

Each row of this table maps the country or region abbreviation code representing a country or region to a numeric code. The mapping is dictated by the third-party product or vendor identified by the string in the PRODUCTVENDOR column.

Column Descriptions:

NameTypeDescription
PRODUCTVENDORVARCHAR (64) NOT NULLString that identifies the third-party product or vendor using this country code for the country or region identified by this country or region abbreviation code.
COUNTRYABBRCHAR (5) NOT NULLCountry or region abbreviation code for the country or region. The name of the country or region are stored in the COUNTRY table.
COUNTRYCODECHAR (5)The internal country or region code for the specified country or region assigned by the third party product or vendor.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PRODUCTVENDOR+COUNTRYABBRPrimary Key