public.city
Documentation | World (PostgreSQL database) |
Schema | public |
Name | city |
Module | World database diagram |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | id | integer | A surrogate primary key used to uniquely identify each city in the table. | |||||
A surrogate primary key used to uniquely identify each city in the table. |
||||||||
2 | name | text | The name of the city. | |||||
The name of the city. |
||||||||
3 | countrycode | character(3) | A foreign key identifying the country that the city belongs to. | |||||
A foreign key identifying the country that the city belongs to. |
||||||||
4 | district | text | The city district. | |||||
The city district. |
||||||||
5 | population | integer | The city population. | |||||
The city population. |
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 |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
city_pkey | id | Primary key. | |
Primary key. |
Used by
Name |
---|
public.city
|
Exported: 2018-11-09 14:22, Last imported: 2018-08-06 09:37