mstr_countries


Description

A listing of countries including currency symbology, official names, and other information concerning the country from standards bodies and international organizations.

General Usage

The table structure as it now stands is based on the data available at: https://datahub.io/core/country-codes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 uuid_generate_v7()
mstr_country_address_format_assocs.country_id mstr_country_address_format_assocs_countries_fk C
mstr_country_name_format_assocs.country_id mstr_country_name_format_assocs_countries_fk R
mstr_country_phone_format_assocs.country_id mstr_country_phone_format_assocs_countries_fk R

The record’s primary key. The definitive identifier of the record in the system.

General Usage

This column is system maintained and should be considered read only in normal operations.
internal_name text 2147483647 null

A candidate key useful for programmatic references to individual records.

General Usage

This column is system maintained and should be considered read only in normal operations.
display_name text 2147483647 √ null

A friendly name and candidate key for the record, suitable for use in user interactions

General Usage

This column is system maintained and should be considered read only in normal operations.
external_name text 2147483647 null

A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
official_name_ar text 2147483647 √ null

Country or Area official Arabic short name from UN Statistics Division
official_name_cn text 2147483647 √ null

Country or Area official Chinese short name from UN Statistics Division
official_name_en text 2147483647 √ null

Country or Area official English short name from UN Statistics Division
official_name_es text 2147483647 √ null

Country or Area official Spanish short name from UN Statistics Division
official_name_fr text 2147483647 √ null

Country or Area official French short name from UN Statistics Division
official_name_ru text 2147483647 √ null

Country or Area official Russian short name from UN Statistics Division
iso3166_1_alpha_2 text 2147483647 √ null

Alpha-2 codes from ISO 3166-1
iso3166_1_alpha_3 text 2147483647 √ null

Alpha-3 codes from ISO 3166-1 (synonymous with World Bank Codes)
iso3166_1_numeric text 2147483647 √ null

Numeric codes from ISO 3166-1
iso4217_currency_alphabetic_code text 2147483647 √ null

ISO 4217 currency alphabetic code
iso4217_currency_country_name text 2147483647 √ null

(ISO4217-currency_country_name) :: ISO 4217 country name
iso4217_currency_minor_unit text 2147483647 √ null

(ISO4217-currency_minor_unit) :: ISO 4217 currency number of minor units
iso4217_currency_name text 2147483647 √ null

(ISO4217-currency_name) :: ISO 4217 currency name
iso4217_currency_numeric_code text 2147483647 √ null

(ISO4217-currency_numeric_code) :: ISO 4217 currency numeric code
cldr_display_name text 2147483647 √ null

(CLDR display name) :: Country’s customary English short name (CLDR)
capital text 2147483647 √ null

Capital city from Geonames
continent text 2147483647 √ null

(Continent) :: Continent from Geonames
ds text 2147483647 √ null

(DS) :: Distinguishing signs of vehicles in international traffic
dial text 2147483647 √ null

Country code from ITU-T recommendation E.164, sometimes followed by area code
edgar text 2147483647 √ null

(EDGAR) :: EDGAR country code from SEC
fips text 2147483647 √ null

(FIPS) :: Codes from the U.S. standard FIPS PUB 10-4
gaul text 2147483647 √ null

(GAUL) :: Global Administrative Unit Layers from the Food and Agriculture Organization
geoname_id text 2147483647 √ null

(Geoname ID) :: Geoname ID
global_code text 2147483647 √ null

(Global Code) :: Country classification from United Nations Statistics Division
global_name text 2147483647 √ null

(Global Name) :: Country classification from United Nations Statistics Division
ioc text 2147483647 √ null

(IOC) :: Codes assigned by the International Olympics Committee
itu text 2147483647 √ null

(ITU) :: Codes assigned by the International Telecommunications Union
intermediate_region_code text 2147483647 √ null

(Intermediate Region Code) :: Country classification from United Nations Statistics Division
intermediate_region_name text 2147483647 √ null

(Intermediate Region Name) :: Country classification from United Nations Statistics Division
languages text 2147483647 √ null

(Languages) :: Languages from Geonames
marc text 2147483647 √ null

(MARC) :: MAchine-Readable Cataloging codes from the Library of Congress
region_code text 2147483647 √ null

(Region Code) :: Country classification from United Nations Statistics Division
region_name text 2147483647 √ null

(Region Name) :: Country classification from United Nations Statistics Division
sub_region_code text 2147483647 √ null

(Sub-region Code) :: Country classification from United Nations Statistics Division
sub_region_name text 2147483647 √ null

(Sub-region Name) :: Country classification from United Nations Statistics Division
tld text 2147483647 √ null

(TLD) :: Top level domain from Geonames
wmo text 2147483647 √ null

(WMO) :: Country abbreviations by the World Meteorological Organization
is_independent text 2147483647 √ null

(is_independent) :: Country status, based on the CIA World Factbook
diag_timestamp_created timestamptz 35,6 now()

The database server date/time when the transaction which created the record started.

General Usage

This column is system maintained and should be considered read only in normal operations.
diag_role_created text 2147483647 null

The database role which created the record.

General Usage

This column is system maintained and should be considered read only in normal operations.
diag_timestamp_modified timestamptz 35,6 now()

The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records.

General Usage

This column is system maintained and should be considered read only in normal operations.
diag_wallclock_modified timestamptz 35,6 clock_timestamp()

The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified.

General Usage

This column is system maintained and should be considered read only in normal operations.
diag_role_modified text 2147483647 null

The database role which modified the record.

General Usage

This column is system maintained and should be considered read only in normal operations.
diag_row_version int8 19 1

The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count.

General Usage

This column is system maintained and should be considered read only in normal operations.

Direct Usage

This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
diag_update_count int8 19 0

Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1.

General Usage

This column is system maintained and should be considered read only in normal operations.

Indexes

Constraint Name Type Sort Column(s)
mstr_countries_pk Primary key Asc id
mstr_countries_display_name_udx Must be unique Asc display_name
mstr_countries_internal_name_udx Must be unique Asc internal_name

Relationships

Close relationships within degrees of separation