Database Table: 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 Name Column Type Column Description
COUNTRYABBR CHARACTER (5)
NOT NULL
Country or region abbreviation code for the country or region. The name of the country or region are stored in the COUNTRY table.
COUNTRYCODE CHARACTER (5)
NULL
The internal country or region code for the specified country or region assigned by the third party product or vendor.
PRODUCTVENDOR VARCHAR (64)
NOT NULL
String 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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034912700 PRODUCTVENDOR, COUNTRYABBR Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable