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 table quotes (
        id serial,
        trivia_id int references trivias(id),
        quote text not null,
        primary key(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 table quotes (
16	id serial,
17	trivia_id int references trivias(id),
18	quote text not null,
19	primary key(id)
20	);
21