The film_actor table

The film_actor table is used to support many-to-many relationships between films and actors. For each actor in each movie, there is a row in the film_actor table.

The film_actor table refers to the film and actor tables using foreign keys.

Table Structure

The structure of the customer table is as follows:

+-------------+-------------------+------+-----+-------------------+-----------------------------------------------+
| Field       | Type              | Null | Key | Default           | Extra                                         |
+-------------+-------------------+------+-----+-------------------+-----------------------------------------------+
| actor_id    | smallint unsigned | NO   | PRI | NULL              |                                               |
| film_id     | smallint unsigned | NO   | PRI | NULL              |                                               |
| last_update | timestamp         | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
+-------------+-------------------+------+-----+-------------------+-----------------------------------------------+

Table Columns

The following table explains all columns in the film_actor table.

Column	Description
`actor_id`	The foreign key that identifies the actor.
`film_id`	The foreign key that identifies the film.
`last_update`	The time when the row was created or last updated.