View tariqapro.v_countries 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
parent_region_id int unsigned 10 0
parent_region_name_en varchar 255
parent_region_name_fr varchar 255
parent_region_comments text 65535  √  null
region_id int unsigned 10 0
region_name_en varchar 255
region_name_fr varchar 255
region_comments text 65535  √  null
country_id varchar 2 ISO 3166-1
country_name_en varchar 255 ISO 3166-2
country_name_fr varchar 255 ISO 3166-2
code_iso2 varchar 2
code_iso3 varchar 3  √  null ISO 3166 (3 alpha)
code_iana varchar 2  √  null Internet Assigned Numbers Authority
code_ioc varchar 3  √  null International Olympic Committee
code_un varchar 3  √  null United Nations, International Traffic Distinguished Signs
code_isonum int 10  √  null ISO 3166 / UN Statistical Division
code_itu varchar 5  √  null International Telecommunication Union codes for international telephone calls
code_ec_comref varchar 3  √  null E.C. COMREF
code_ec_min varchar 3  √  null E.C. MIN Coding
code_ec_sysper varchar 3  √  null E.C. Sysper Coding
code_ec_trade int 10  √  null E.C. Trade Coding
code_janes_folder varchar 10  √  null Jane's Sentinel Folder name
code_janes_base varchar 10  √  null Jane's Sentinel filenames base
code_oxan varchar 255  √  null Oxford Analytica Country Name
code_ec_comref_del varchar 3  √  null E.C. COMREF - DELEGATIONS.PAY_CD
is_eu_member enum 2 0 1 if the Country belongs to the European Union
is_official enum 2 1 0 If the country is not officialy recognised
cluster_id int unsigned 10  √  null
parent_country_id varchar 2  √  null "Parent" country or NULL

Analyzed at Wed Apr 25 13:31 CEST 2012