1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
|
table "public.film"
Name | Type | Nullable | Default | Size | Decimal Digits | Radix | Octet Length
----------------------+--------------------------------+----------+---------------------------------------+------+----------------+-------+--------------
film_id | integer | "NO" | nextval('film_film_id_seq'::regclass) | 32 | 0 | 2 | 0
title | character varying(255) | "NO" | | 255 | 0 | 10 | 1020
description | text | "YES" | | 0 | 0 | 10 | 1073741824
release_year | integer | "YES" | | 32 | 0 | 2 | 0
language_id | smallint | "NO" | | 16 | 0 | 2 | 0
original_language_id | smallint | "YES" | | 16 | 0 | 2 | 0
rental_duration | smallint | "NO" | 3 | 16 | 0 | 2 | 0
rental_rate | numeric(4,2) | "NO" | 4.99 | 4 | 2 | 10 | 0
length | smallint | "YES" | | 16 | 0 | 2 | 0
replacement_cost | numeric(5,2) | "NO" | 19.99 | 5 | 2 | 10 | 0
rating | USER-DEFINED | "YES" | 'G'::mpaa_rating | 0 | 0 | 10 | 0
last_update | timestamp(6) without time zone | "NO" | now() | 6 | 0 | 10 | 0
special_features | ARRAY | "YES" | | 0 | 0 | 10 | 0
fulltext | tsvector | "NO" | | 0 | 0 | 10 | 0
Indexes:
"film_fulltext_idx" gist (fulltext)
"film_pkey" PRIMARY_KEY, UNIQUE, btree (film_id)
"idx_fk_language_id" btree (language_id)
"idx_fk_original_language_id" btree (original_language_id)
"idx_title" btree (title)
Foreign-key constraints:
"film_language_id_fkey" FOREIGN KEY (language_id) REFERENCES language(language_id) ON UPDATE CASCADE ON DELETE RESTRICT
"film_original_language_id_fkey" FOREIGN KEY (original_language_id) REFERENCES language(language_id) ON UPDATE CASCADE ON DELETE RESTRICT
Referenced by:
TABLE "film_actor" CONSTRAINT "film_actor_film_id_fkey" FOREIGN KEY (film_id) REFERENCES film(film_id) ON UPDATE CASCADE ON DELETE RESTRICT
TABLE "film_category" CONSTRAINT "film_category_film_id_fkey" FOREIGN KEY (film_id) REFERENCES film(film_id) ON UPDATE CASCADE ON DELETE RESTRICT
TABLE "inventory" CONSTRAINT "inventory_film_id_fkey" FOREIGN KEY (film_id) REFERENCES film(film_id) ON UPDATE CASCADE ON DELETE RESTRICT
Triggers:
"film_fulltext_trigger" CREATE TRIGGER film_fulltext_trigger BEFORE INSERT OR UPDATE ON film FOR EACH ROW EXECUTE FUNCTION tsvector_update_trigger('fulltext', 'pg_catalog.english', 'title', 'description')
"last_updated" CREATE TRIGGER last_updated BEFORE UPDATE ON film FOR EACH ROW EXECUTE FUNCTION last_updated()
table "public.film_actor"
Name | Type | Nullable | Default | Size | Decimal Digits | Radix | Octet Length
-------------+--------------------------------+----------+---------+------+----------------+-------+--------------
actor_id | smallint | "NO" | | 16 | 0 | 2 | 0
film_id | smallint | "NO" | | 16 | 0 | 2 | 0
last_update | timestamp(6) without time zone | "NO" | now() | 6 | 0 | 10 | 0
Indexes:
"film_actor_pkey" PRIMARY_KEY, UNIQUE, btree (actor_id, film_id)
"idx_fk_film_id" btree (film_id)
Foreign-key constraints:
"film_actor_actor_id_fkey" FOREIGN KEY (actor_id) REFERENCES actor(actor_id) ON UPDATE CASCADE ON DELETE RESTRICT
"film_actor_film_id_fkey" FOREIGN KEY (film_id) REFERENCES film(film_id) ON UPDATE CASCADE ON DELETE RESTRICT
Triggers:
"last_updated" CREATE TRIGGER last_updated BEFORE UPDATE ON film_actor FOR EACH ROW EXECUTE FUNCTION last_updated()
table "public.film_category"
Name | Type | Nullable | Default | Size | Decimal Digits | Radix | Octet Length
-------------+--------------------------------+----------+---------+------+----------------+-------+--------------
film_id | smallint | "NO" | | 16 | 0 | 2 | 0
category_id | smallint | "NO" | | 16 | 0 | 2 | 0
last_update | timestamp(6) without time zone | "NO" | now() | 6 | 0 | 10 | 0
Indexes:
"film_category_pkey" PRIMARY_KEY, UNIQUE, btree (film_id, category_id)
Foreign-key constraints:
"film_category_category_id_fkey" FOREIGN KEY (category_id) REFERENCES category(category_id) ON UPDATE CASCADE ON DELETE RESTRICT
"film_category_film_id_fkey" FOREIGN KEY (film_id) REFERENCES film(film_id) ON UPDATE CASCADE ON DELETE RESTRICT
Triggers:
"last_updated" CREATE TRIGGER last_updated BEFORE UPDATE ON film_category FOR EACH ROW EXECUTE FUNCTION last_updated()
view "public.film_list"
Name | Type | Nullable | Default | Size | Decimal Digits | Radix | Octet Length
-------------+------------------------+----------+---------+------+----------------+-------+--------------
fid | integer | "YES" | | 32 | 0 | 2 | 0
title | character varying(255) | "YES" | | 255 | 0 | 10 | 1020
description | text | "YES" | | 0 | 0 | 10 | 1073741824
category | character varying(25) | "YES" | | 25 | 0 | 10 | 100
price | numeric(4,2) | "YES" | | 4 | 2 | 10 | 0
length | smallint | "YES" | | 16 | 0 | 2 | 0
rating | USER-DEFINED | "YES" | | 0 | 0 | 10 | 0
actors | text | "YES" | | 0 | 0 | 10 | 1073741824
Sequence "public.film_film_id_seq"
Type | Start | Min | Max | Increment | Cycles?
--------+-------+-----+---------------------+-----------+---------
bigint | 1 | 1 | 9223372036854775807 | 1 | "NO"
Index "public.film_actor_pkey"
Name | Type
----------+----------
actor_id | smallint
film_id | smallint
primary key, btree, for table film_actor
Index "public.film_category_pkey"
Name | Type
-------------+----------
film_id | smallint
category_id | smallint
primary key, btree, for table film_category
Index "public.film_fulltext_idx"
Name | Type
----------+-----------
fulltext | gtsvector
gist, for table film
Index "public.film_pkey"
Name | Type
---------+---------
film_id | integer
primary key, btree, for table film
|
