Table CITY

This table contains a list of cities. The table is referred to by a foreign key in the ADDRESS table and refers to the COUNTRY table using a foreign key.

Columns

This table contains 4 columns.

CITY_ID

INTEGER · NOT NULL

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

CITY

VARCHAR(50) · NOT NULL

The name of the city.

COUNTRY_ID

INTEGER · NOT NULL

A foreign key identifying the country that the city belongs to.

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.

CITY: CITY_ID

Foreign keys

This table has one foreign key.

FK_CITY_COUNTRY: COUNTRY_ID » COUNTRY (COUNTRY_ID) · ON UPDATE CASCADE · ON DELETE NO ACTION

Indices

This table has 3 indices.

FK_CITY_COUNTRY: COUNTRY_ID
IDX_CITY_FK_COUNTRY_ID: COUNTRY_ID
RDB$PRIMARY4: CITY_ID