View tariqapro.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
country_id varchar 2 ISO 3166-1
name_en varchar 255 ISO 3166-2
name_fr varchar 255 ISO 3166-2
parent_country_id varchar 2  √  null "Parent" country or NULL
eu_member enum 2 0 1 if the Country belongs to the European Union
continent_id int unsigned 10  √  null Ref to the continent
official enum 2 1 0 If the country is not officialy recognised
cluster_id int unsigned 10  √  null

Analyzed at Wed Apr 25 13:31 CEST 2012