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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034912700 | PRODUCTVENDOR, COUNTRYABBR | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|