begin;
create table sites (
	name	text primary key,
	lat	float,
	lon	float,
	year	integer, -- year discovered
	narrative	text
);

create table fossils (
	name	text primary key,
	common_name	text, -- common name
	site	text references sites, -- where found
	year	integer, -- year discovered
	narrative	text
);

create table species (
	name	text primary key, -- scientific name
	common_name	text, -- a short name e.g. "Neanderthal"
	narrative	text
);
commit;
