public.country

Information about countries of the world.

Columns

		Name	Data type	References	Description
	1	code	character(3)		Primary key. ISO country code.
Primary key. ISO country code.
	2	name	text		The name of the country.
The name of the country.
	3	continent	text		The country's continent
The country's continent
	4	region	text		The country's region name.
The country's region name.
	5	surfacearea	real		The country's surface area.
The country's surface area.
	6	indepyear	smallint		The year from which the country is independent.
The year from which the country is independent.
	7	population	integer		The country's population.
The country's population.
	8	lifeexpectancy	real		Average life expectancy.
Average life expectancy.
	9	gnp	numeric(10, 2)		Gross national product.
Gross national product.
	10	gnpold	numeric(10, 2)		Gross national product - old value.
Gross national product - old value.
	11	localname	text		The country's local name.
The country's local name.
	12	governmentform	text		The country's goverment form.
The country's goverment form.
	13	headofstate	text		The head of state full name.
The head of state full name.
	14	capital	integer	public.city	The country's capital. Foreign key to city.id
The country's capital. Foreign key to city.id References: public.city
	15	code2	character(2)		The second country code.
The second country code.

Relations

Foreign table	Primary table	Join	Title / Name / Description
public.country	public.city	public.country.capital = public.city.id	country_capital_fkey Foreign key constraint referencing city.id
public.country.capital = public.city.id Name: country_capital_fkey Foreign key constraint referencing city.id
public.countrylanguage	public.country	public.countrylanguage.countrycode = public.country.code	countrylanguage_countrycode_fkey Foreign key constraint referencing country.code
public.countrylanguage.countrycode = public.country.code Name: countrylanguage_countrycode_fkey Foreign key constraint referencing country.code

Unique keys

	Key name	Columns	Description
	country_pkey	code	Primary key.
Primary key.

Uses

Name
public.country
public.city

Used by

Name
public.country
public.countrylanguage

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