Line # Revision Author
1 83 dpavlin create table films (
2 id serial,
3 title text not null,
4 year int,
5 primary key(id)
6 );
7
8 create table trivias (
9 id serial,
10 film_id int references films(id),
11 trivia text not null,
12 primary key(id)
13 );
14
15 84 dpavlin create index trivias_film_id on trivias(film_id) ;
16
17 83 dpavlin create table quotes (
18 id serial,
19 trivia_id int references trivias(id),
20 quote text not null,
21 primary key(id)
22 );
23
24 84 dpavlin create index quotes_trivia_id on quotes(trivia_id) ;
25