country
Documentation | World (MySQL database) |
Name | country |
Module | World database diagram |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Code | char(3) | Primary key. ISO country code. | |||||
Primary key. ISO country code. |
||||||||
2 | Name | char(52) | The name of the country. | |||||
The name of the country. |
||||||||
3 | Continent | enum | Default: Asia | The country's continent | ||||
The country's continent Default: Asia |
||||||||
4 | Region | char(26) | The country's region name. | |||||
The country's region name. |
||||||||
5 | SurfaceArea | float(10, 2) | Default: 0.00 | The country's surface area. | ||||
The country's surface area. Default: 0.00 |
||||||||
6 | IndepYear | smallint(5, 0) | The year from which the country is independent. | |||||
The year from which the country is independent. |
||||||||
7 | Population | int(10, 0) | Default: 0 | The country's population. | ||||
The country's population. Default: 0 |
||||||||
8 | LifeExpectancy | float(3, 1) | Average life expectancy. | |||||
Average life expectancy. |
||||||||
9 | GNP | float(10, 2) | Gross national product. | |||||
Gross national product. |
||||||||
10 | GNPOld | float(10, 2) | Gross national product - old value. | |||||
Gross national product - old value. |
||||||||
11 | LocalName | char(45) | The country's local name. | |||||
The country's local name. |
||||||||
12 | GovernmentForm | char(45) | The country's goverment form. | |||||
The country's goverment form. |
||||||||
13 | HeadOfState | char(60) | The head of state full name. | |||||
The head of state full name. |
||||||||
14 | Capital | int(10, 0) | The country's capital. Foreign key to city.id | |||||
The country's capital. Foreign key to city.id |
||||||||
15 | Code2 | char(2) | The second country code. | |||||
The second country code. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
city | country | city.CountryCode = country.Code | city_ibfk_1 Foreign key constraint referencing country.Code |
|
city.CountryCode = country.Code Name: city_ibfk_1Foreign key constraint referencing country.Code |
||||
countrylanguage | country | countrylanguage.CountryCode = country.Code | countryLanguage_ibfk_1 Foreign key constraint referencing country.Code |
|
countrylanguage.CountryCode = country.Code Name: countryLanguage_ibfk_1Foreign key constraint referencing country.Code |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PRIMARY | Code | Primary key. | |
Primary key. |
Used by
Name |
---|
country
|
Exported: 2018-11-09 14:21, Last imported: 2018-08-06 09:22