Table meta_common.countries_equiv
Country codes conversion table

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
v_countries.country_id Implied Constraint R
countries.country_id fk_countries_equiv_countries C
iso3 varchar 3  √  null ISO 3166 (3 alpha)
iana varchar 2  √  null Internet Assigned Numbers Authority
ioc varchar 3  √  null International Olympic Committee
un varchar 3  √  null United Nations, International Traffic Distinguished Signs
isonum int 10  √  null ISO 3166 / UN Statistical Division
itu varchar 5  √  null International Telecommunication Union codes for international telephone calls
ec_comref varchar 3  √  null E.C. COMREF
ec_min varchar 3  √  null E.C. MIN Coding
ec_sysper varchar 3  √  null E.C. Sysper Coding
ec_trade int 10  √  null E.C. Trade Coding
janes_folder varchar 10  √  null Jane's Sentinel Folder name
janes_base varchar 10  √  null Jane's Sentinel filenames base
oxan varchar 255  √  null Oxford Analytica Country Name
ec_comref_del varchar 3  √  null E.C. COMREF - DELEGATIONS.PAY_CD
global_atlas varchar 20  √  null The FIPS global atlas code
wikipedia_name varchar 255  √  null The Wikipedia country name

Analyzed at Wed Apr 25 13:19 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
country_id Primary key Asc PRIMARY

Close relationships  within of separation: