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
-
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