city
| Documentation | World (MySQL database) |
| Name | city |
| Module | World database diagram |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ID | int(10, 0) | Identity / Auto increment column | 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. Identity / Auto increment column |
||||||||
| 2 | Name | char(35) | The name of the city. | |||||
| The name of the city. |
||||||||
| 3 | CountryCode | char(3) | country | A foreign key identifying the country that the city belongs to. | ||||
| A foreign key identifying the country that the city belongs to. References: country |
||||||||
| 4 | District | char(20) | The city district. | |||||
| The city district. |
||||||||
| 5 | Population | int(10, 0) | Default: 0 | The city population. | ||||
| The city population. Default: 0 |
||||||||
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_1Foreign key constraint referencing country.Code |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PRIMARY | ID | Primary key. | |
| Primary key. | |||
Uses
| Name |
|---|
|
city
|
Exported: 2018-11-09 14:21, Last imported: 2018-08-06 09:22