Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
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 |
|
|
|
|
|
country_name_en |
varchar |
255 |
|
|
|
|
|
country_name_fr |
varchar |
255 |
|
|
|
|
|
code_iso2 |
varchar |
2 |
|
|
|
|
|
code_iso3 |
varchar |
3 |
√ |
|
null |
|
|
code_iana |
varchar |
2 |
√ |
|
null |
|
|
code_ioc |
varchar |
3 |
√ |
|
null |
|
|
code_un |
varchar |
3 |
√ |
|
null |
|
|
code_isonum |
int |
10 |
√ |
|
null |
|
|
code_itu |
varchar |
5 |
√ |
|
null |
|
|
code_ec_comref |
varchar |
3 |
√ |
|
null |
|
|
code_ec_min |
varchar |
3 |
√ |
|
null |
|
|
code_ec_sysper |
varchar |
3 |
√ |
|
null |
|
|
code_ec_trade |
int |
10 |
√ |
|
null |
|
|
code_janes_folder |
varchar |
10 |
√ |
|
null |
|
|
code_janes_base |
varchar |
10 |
√ |
|
null |
|
|
code_oxan |
varchar |
255 |
√ |
|
null |
|
|
code_ec_comref_del |
varchar |
3 |
√ |
|
null |
|
|
is_eu_member |
enum |
2 |
|
|
0 |
|
|
is_official |
enum |
2 |
|
|
1 |
|
|
cluster_id |
int unsigned |
10 |
√ |
|
null |
|
|
parent_country_id |
varchar |
2 |
√ |
|
null |
|
|
Analyzed at Wed Apr 25 13:31 CEST 2012
|