blob: f356f41bec4ee796cd2c15db0557abf7f3f8b029 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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
);
|