| Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
|
country
|
Code
|
char(3)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
country
|
Name
|
char(52)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
country
|
Continent
|
enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America')
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
country
|
Region
|
char(26)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
country
|
SurfaceArea
|
float(10,2)
|
|
|
|
|
NULL
|
NULL
|
|
|
country
|
IndepYear
|
smallint(6)
|
|
|
|
|
NULL
|
NULL
|
|
|
country
|
Population
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
|
country
|
LifeExpectancy
|
float(3,1)
|
|
|
|
|
NULL
|
NULL
|
|
|
country
|
GNP
|
float(10,2)
|
|
|
|
|
NULL
|
NULL
|
|
|
country
|
GNPOld
|
float(10,2)
|
|
|
|
|
NULL
|
NULL
|
|
|
country
|
LocalName
|
char(45)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
country
|
GovernmentForm
|
char(45)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
country
|
HeadOfState
|
char(60)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
|
country
|
Capital
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
|
country
|
Code2
|
char(2)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|