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	dpavlin	83	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