The city table
This article introduces the structure of the city table in the Sakila database.
The city table contains a list of cities.
The city table refers to the the country table using a foreign key.
The address table refers to the city table using a foreign key.
Table Structure
The structure of the city table is as follows:
+-------------+-------------------+------+-----+-------------------+-----------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------------+------+-----+-------------------+-----------------------------------------------+
| city_id | smallint unsigned | NO | PRI | NULL | auto_increment |
| city | varchar(50) | NO | | NULL | |
| country_id | smallint unsigned | NO | MUL | NULL | |
| last_update | timestamp | NO | | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
+-------------+-------------------+------+-----+-------------------+-----------------------------------------------+
Table Columns
The following table explains all columns in the city table.
| Column | Description |
|---|---|
city_id |
The surrogate primary key used to uniquely identify each city in the table. |
city |
City name. |
country_id |
A foreign key that identifies the country to which the city belongs. |
last_update |
The time when the row was created or last updated. |