city
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| ID (Primary) | int(11) | No | ||||
| Name | char(35) | No | ||||
| CountryCode | char(3) | No | country -> Code | |||
| District | char(20) | No | ||||
| Population | int(11) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | ID | 4321 | A | No | |
| CountryCode | BTREE | No | No | CountryCode | 617 | A | No |
country
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | Code | 226 | A | No |
countrylanguage
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| CountryCode (Primary) | char(3) | No | country -> Code | |||
| Language (Primary) | char(30) | No | ||||
| IsOfficial | enum('T', 'F') | No | F | |||
| Percentage | float(4,1) | No | 0.0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | CountryCode | 578 | A | No | |
| Language | 1157 | A | No | |||||
| CountryCode | BTREE | No | No | CountryCode | 578 | A | No |