From 2080c821ef01f61ee8f6219e51d7edc065228fe6 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Hugo=20H=C3=B6rnquist?= Date: Mon, 30 Sep 2019 18:02:16 +0200 Subject: Mon, 30 Sep 2019 18:02:16 +0200 --- TaskApp.wiki | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 53 insertions(+) create mode 100644 TaskApp.wiki (limited to 'TaskApp.wiki') diff --git a/TaskApp.wiki b/TaskApp.wiki new file mode 100644 index 0000000..f356f41 --- /dev/null +++ b/TaskApp.wiki @@ -0,0 +1,53 @@ + +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 +); -- cgit v1.2.3