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