dic_country

268 rows


Description

Dictionary of countries and seas based on ISO-3166, some minor modifications

Columns

Column Type Size Nulls Auto Default Children Parents Comments
iso_code bpchar 2 √ null
dic_continent.iso_code Implied Constraint R

Two-letter country code (ISO 3166-1 alpha-2)
country varchar 64 null
site.country dic_country_site R

English country name
full_name varchar 128 √ null

Full English country name
iso3 varchar 3 √ null

Three-letter country code (ISO 3166-1 alpha-3)
iso_number int4 10 √ null

Three-digit country number (ISO 3166-1 numeric)
continent_code varchar 2 null
dic_continent.iso_code dic_continent_dic_country_fk R

Indexes

Constraint Name Type Sort Column(s)
dic_country_pkey Primary key Asc country
country_lower_idx Performance

Relationships

Close relationships within degrees of separation