country

Information about countries of the world.

Columns

		Name	Data type	Attributes	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_1 Foreign 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_1 Foreign key constraint referencing country.Code

Unique keys

	Key name	Columns	Description
	PRIMARY	Code	Primary key.
Primary key.

Used by

Exported: 2018-11-09 14:21, Last imported: 2018-08-06 09:22