public.film_category

Description

Columns

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

Constraints

Name	Type	Definition
film_category_category_id_fkey	FOREIGN KEY	FOREIGN KEY (category_id) REFERENCES category(category_id) ON UPDATE CASCADE ON DELETE RESTRICT
film_category_pkey	PRIMARY KEY	PRIMARY KEY (film_id, category_id)
film_category_film_id_fkey	FOREIGN KEY	FOREIGN KEY (film_id) REFERENCES film(film_id) ON UPDATE CASCADE ON DELETE RESTRICT

Indexes

Name	Definition
film_category_pkey	CREATE UNIQUE INDEX film_category_pkey ON public.film_category USING btree (film_id, category_id)

Triggers

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

Relations