public.film

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
film_id	integer	nextval('film_film_id_seq'::regclass)	false	public.film_actor public.film_category public.inventory
title	text		false
description	text		true
release_year	year		true
language_id	integer		false		public.language
original_language_id	integer		true		public.language
rental_duration	smallint	3	false
rental_rate	numeric(4,2)	4.99	false
length	smallint		true
replacement_cost	numeric(5,2)	19.99	false
rating	mpaa_rating	'G'::mpaa_rating	true
last_update	timestamp with time zone	now()	false
special_features	text[]		true
fulltext	tsvector		false

Constraints

Name	Type	Definition
film_pkey	PRIMARY KEY	PRIMARY KEY (film_id)
film_language_id_fkey	FOREIGN KEY	FOREIGN KEY (language_id) REFERENCES language(language_id) ON UPDATE CASCADE ON DELETE RESTRICT
film_original_language_id_fkey	FOREIGN KEY	FOREIGN KEY (original_language_id) REFERENCES language(language_id) ON UPDATE CASCADE ON DELETE RESTRICT

Indexes

Name	Definition
film_pkey	CREATE UNIQUE INDEX film_pkey ON public.film USING btree (film_id)
film_fulltext_idx	CREATE INDEX film_fulltext_idx ON public.film USING gist (fulltext)
idx_fk_language_id	CREATE INDEX idx_fk_language_id ON public.film USING btree (language_id)
idx_fk_original_language_id	CREATE INDEX idx_fk_original_language_id ON public.film USING btree (original_language_id)
idx_title	CREATE INDEX idx_title ON public.film USING btree (title)

Triggers

Name	Definition
film_fulltext_trigger	CREATE TRIGGER film_fulltext_trigger BEFORE INSERT OR UPDATE ON public.film FOR EACH ROW EXECUTE FUNCTION tsvector_update_trigger('fulltext', 'pg_catalog.english', 'title', 'description')
last_updated	CREATE TRIGGER last_updated BEFORE UPDATE ON public.film FOR EACH ROW EXECUTE FUNCTION last_updated()

Relations