public.film_actor

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
actor_id	integer		false		public.actor
film_id	integer		false		public.film
last_update	timestamp with time zone	now()	false

Constraints

Name	Type	Definition
film_actor_actor_id_fkey	FOREIGN KEY	FOREIGN KEY (actor_id) REFERENCES actor(actor_id) ON UPDATE CASCADE ON DELETE RESTRICT
film_actor_pkey	PRIMARY KEY	PRIMARY KEY (actor_id, film_id)
film_actor_film_id_fkey	FOREIGN KEY	FOREIGN KEY (film_id) REFERENCES film(film_id) ON UPDATE CASCADE ON DELETE RESTRICT

Indexes

Name	Definition
film_actor_pkey	CREATE UNIQUE INDEX film_actor_pkey ON public.film_actor USING btree (actor_id, film_id)
idx_fk_film_id	CREATE INDEX idx_fk_film_id ON public.film_actor USING btree (film_id)

Triggers

Name	Definition
last_updated	CREATE TRIGGER last_updated BEFORE UPDATE ON public.film_actor FOR EACH ROW EXECUTE FUNCTION last_updated()

Relations