Table postgres.public.film Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
film_id serial 10  √  nextval('film_film_id_seq'::regclass)
film_actor.film_id film_actor_film_id_fkey R
film_category.film_id film_category_film_id_fkey R
inventory.film_id inventory_film_id_fkey R
title varchar 255
description text 2147483647  √  null
release_year year 10  √  null
language_id int2 5
language.language_id film_language_id_fkey R
original_language_id int2 5  √  null
language.language_id film_original_language_id_fkey R
rental_duration int2 5 3
rental_rate numeric 4,2 4.99
length int2 5  √  null
replacement_cost numeric 5,2 19.99
rating mpaa_rating 2147483647  √  'G'::mpaa_rating
last_update timestamp 29,6 now()
special_features _text 2147483647  √  null
fulltext tsvector 2147483647

Table contained 1,000 rows at Mon Feb 20 18:07 CET 2023

Indexes:
Column(s) Type Sort Constraint Name
film_id Primary key Asc film_pkey
fulltext Performance Asc film_fulltext_idx
language_id Performance Asc idx_fk_language_id
original_language_id Performance Asc idx_fk_original_language_id
title Performance Asc idx_title

Close relationships  within of separation: