5.1.4 The city Table

The city table contains a list of cities.

The city table is referred to by a foreign key in the address table and refers to the country table using a foreign key.

  • city_id: A surrogate primary key used to uniquely identify each city in the table.

  • city: The name of the city.

  • country_id: A foreign key identifying the country that the city belongs to.

  • last_update: The time that the row was created or most recently updated.

Download this Manual
PDF (US Ltr) - 177.1Kb
PDF (A4) - 176.7Kb