The actor table

The actor table lists information for all the actors, includes first name and last name of actors.

The actor table is joined to the film table. The relationship between actor and film table is in the film_actor table. There is a many-to-many relationship between actors and films.

Table Structure

The structure of the actor table is as follows:

+-------------+-------------------+------+-----+-------------------+-----------------------------------------------+
| Field       | Type              | Null | Key | Default           | Extra                                         |
+-------------+-------------------+------+-----+-------------------+-----------------------------------------------+
| actor_id    | smallint unsigned | NO   | PRI | NULL              | auto_increment                                |
| first_name  | varchar(45)       | NO   |     | NULL              |                                               |
| last_name   | varchar(45)       | NO   | MUL | NULL              |                                               |
| last_update | timestamp         | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
+-------------+-------------------+------+-----+-------------------+-----------------------------------------------+

Table Columns

The following table explains all columns in the actor table.

Column	Description
`actor_id`	The surrogate primary key used to uniquely identify each actor in the table.
`first_name`	The actor’s first name.
`last_name`	The actor’s last name.
`last_update`	The time when the row was created or last updated.