Table meta_common.countries
List of countries (ISO 3166-1 and 3166-2)

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
country_id varchar 2
countries.parent_country_id fk_countries_parents R
countries_equiv.country_id fk_countries_equiv_countries C
regions_countries.country_id fk_regions_countries_countries C
ISO 3166-1
name_en varchar 255 ISO 3166-2
name_fr varchar 255 ISO 3166-2
parent_country_id varchar 2  √  null
countries.country_id fk_countries_parents R
"Parent" country or NULL
eu_member enum 2 0 1 if the Country belongs to the European Union
continent_id int unsigned 10  √  null
continents.continent_id fk_countries_continents R
Ref to the continent
official enum 2 1 0 If the country is not officialy recognised
cluster_id int unsigned 10  √  null
clusters.cluster_id fk_countries_clusters R
capital_city varchar 255  √  null
capital_adm varchar 255  √  null
region_id int unsigned 10  √  null
official_regions.region_id FK_countries_official_regions R
other_country enum 2  √  0 If set to true, it means that there is another country with a similar name.

Analyzed at Wed Apr 25 13:19 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
country_id Primary key Asc PRIMARY
cluster_id Performance Asc fk_countries_clusters
continent_id Performance Asc fk_countries_continents
region_id Performance Asc FK_countries_official_regions
parent_country_id Performance Asc fk_countries_parents
name_en Performance Asc idx_countries_name_en
name_fr Performance Asc idx_countries_name_fr

Close relationships  within of separation: