5.1.5 The country Table

The country table contains a list of countries.

The country table is referred to by a foreign key in the city table.

  • country_id: A surrogate primary key used to uniquely identify each country in the table.

  • country: The name of the country.

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