Table COUNTRY

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

Columns

This table contains 3 columns.

COUNTRY_ID

INTEGER · NOT NULL

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

COUNTRY

VARCHAR(50) · NOT NULL

The name of the country.

LAST_UPDATE

TIMESTAMP · NOT NULL · DEFAULT 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.

RDB$PRIMARY5

COUNTRY_ID