Skip to content

Table FILM_TEXT

This table contains the FILM_ID, TITLE and DESCRIPTION columns of the FILM table, with the contents of the table kept in synchrony with the FILM table by means of triggers on film table INSERT, UPDATE and DELETE operations.

Columns

This table contains 3 columns.

FILM_ID

INTEGER · NOT NULL

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

TITLE

VARCHAR(255) · NOT NULL

The title of the film.

DESCRIPTION

BLOB subtype text

A short description or plot summary of the film.

Primary key

This table has a primary key.

FILM_TEXT

FILM_ID

Indices

This table has one index.

RDB$PRIMARY10

FILM_ID