Mon, 30 Sep 2019 18:02:16 +0200

1 files changed, 53 insertions, 0 deletions

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 <id>
+tt list <id>
+
+--------------------------------------------------
+
+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
+);