Column | Type | Null | Default | Comments |
---|---|---|---|---|
ID (Primary) | int(11) | No | ||
Name | char(35) | No | ||
CountryCode | char(3) | No | ||
District | char(20) | No | ||
Population | int(11) | No | 0 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 4079 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Code (Primary) | char(3) | No | ||
Name | char(52) | No | ||
Continent | enum('Asia', 'Europe', 'North America', 'Africa', 'Oceania', 'Antarctica', 'South America') | No | Asia | |
Region | char(26) | No | ||
SurfaceArea | float(10,2) | No | 0.00 | |
IndepYear | smallint(6) | Yes | NULL | |
Population | int(11) | No | 0 | |
LifeExpectancy | float(3,1) | Yes | NULL | |
GNP | float(10,2) | Yes | NULL | |
GNPOld | float(10,2) | Yes | NULL | |
LocalName | char(45) | No | ||
GovernmentForm | char(45) | No | ||
HeadOfState | char(60) | Yes | NULL | |
Capital | int(11) | Yes | NULL | |
Code2 | char(2) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Code | 239 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CountryCode (Primary) | char(3) | No | ||
Language (Primary) | char(30) | No | ||
IsOfficial | enum('T', 'F') | No | F | |
Percentage | float(4,1) | No | 0.0 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | CountryCode | A | No | ||
Language | 984 | A | No |