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