notation: item :: item of type [item] :: list of item's {item} :: optional item -------------------------------------------------- [project] project: - title - started - {deadline} - [link] - [update] update: - title - pub-date - {body} -------------------------------------------------- tt list tt note tt list -------------------------------------------------- sqlite example tables create table projects ( id primary key not null, title text not null, started datetime not null, deadline datetime ); create table links ( id primary key not null, project_id integer not null, url text ); create table updates ( id primary key not null, project_id integer not null, pub_date datetime not null, title text not null, body text );