Repository List / pgestraier / trunk / data / trivia.sql @ HEAD

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) ;