Table FILM_ACTOR

This table is used to support a many-to-many relationship between films and actors. For each actor in a given film, there will be one row in the FILM_ACTOR table listing the actor and film. The table refers to the FILM and ACTOR tables using foreign keys.

Columns

This table contains 3 columns.

ACTOR_ID

INTEGER · NOT NULL

A foreign key identifying the actor.

FILM_ID

INTEGER · NOT NULL

A foreign key identifying the film.

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.

FILM_ACTOR

ACTOR_ID, FILM_ID

Foreign keys

This table has one foreign key.

FK_FILM_ACTOR_ACTOR

ACTOR_ID » ACTOR (ACTOR_ID) · ON UPDATE CASCADE · ON DELETE NO ACTION

FK_FILM_ACTOR_FILM

FILM_ID » FILM (FILM_ID) · ON UPDATE CASCADE · ON DELETE NO ACTION

Indices

This table has 5 indices.

FILM_ACTOR_IDX_FK_ACTOR

ACTOR_ID

FILM_ACTOR_IDX_FK_FILM

FILM_ID

FK_FILM_ACTOR_ACTOR

ACTOR_ID

FK_FILM_ACTOR_FILM

FILM_ID

RDB$PRIMARY8

ACTOR_ID, FILM_ID