trunk/data/trivia.sql

create table films (
        id serial,
        title text not null,
        year int,
        primary key(id)
);

create table trivias (
        id serial,
        film_id int references films(id),
        trivia text not null,
        primary key(id)
);

create index trivias_film_id on trivias(film_id) ;

create table quotes (
        id serial,
        trivia_id int references trivias(id),
        quote text not null,
        primary key(id)
);

create index quotes_trivia_id on quotes(trivia_id) ;

1	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	create index trivias_film_id on trivias(film_id) ;
16
17	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	create index quotes_trivia_id on quotes(trivia_id) ;
25