film_actor

Documentation	Sakila
Name	film_actor
Module	Inventory

The film_actor 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 film_actor table refers to the film and actor tables using foreign keys.

Columns

		Name	Data type	Attributes	References	Description
	1	actor_id	unsigned smallint(5, 0)		actor	A foreign key identifying the actor.
A foreign key identifying the actor. References: actor
	2	film_id	unsigned smallint(5, 0)		film	A foreign key identifying the film.
A foreign key identifying the film. References: film
	3	last_update	timestamp	Default: CURRENT_TIMESTAMP		The time that the row was created or most recently updated.
The time that the row was created or most recently updated. Default: CURRENT_TIMESTAMP

Relations

Foreign table	Primary table	Join	Title / Name / Description
film_actor	actor	film_actor.actor_id = actor.actor_id	fk_film_actor_actor Foreign key constraint referencing actor.actor_id
film_actor.actor_id = actor.actor_id Name: fk_film_actor_actor Foreign key constraint referencing actor.actor_id
film_actor	film	film_actor.film_id = film.film_id	fk_film_actor_film Foreign key constraint referencing film.film_id
film_actor.film_id = film.film_id Name: fk_film_actor_film Foreign key constraint referencing film.film_id

Unique keys

	Key name	Columns	Description
	PRIMARY	actor_id, film_id	Primary key.
Primary key.

Uses

Name
film_actor
actor
film

Exported: 2018-10-12 17:43, Last imported: 2018-08-06 10:44