public.country
Documentation | World (PostgreSQL database) |
Schema | public |
Name | country |
Module | World database diagram |
Columns
Key | Name | Data type | Null | Attributes | 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_fkeyForeign 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_fkeyForeign key constraint referencing country.code |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
country_pkey | code | Primary key. | |
Primary key. |
Uses
Name |
---|
public.country
|
Used by
Name |
---|
public.country
|
Exported: 2018-11-09 14:22, Last imported: 2018-08-06 09:37