Table country

This table contains a list of countries. The table is referred to by a foreign key in the CITY table.

Schema

This table belongs to schema sakila.

Columns

This table contains 3 columns.

country_id

smallint · NOT NULL

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

country

character varying(50) · NOT NULL

The name of the country.

last_update

timestamp(0) without time zone · NOT NULL · CURRENT_TIMESTAMP

When the row was created or most recently updated.

Primary key

This table has a primary key.

country

country_id

Indices

This table has one index.

country_pkey

country_id