5 CREATE TABLE process_children (
6 parent_id INTEGER NOT NULL,
7 child_id INTEGER NOT NULL,
8 FOREIGN KEY (parent_id) REFERENCES processes(id),
9 FOREIGN KEY (child_id) REFERENCES processes(id)
11 CREATE TABLE process_descriptions (
12 process_id INTEGER NOT NULL,
13 timestamp TEXT NOT NULL,
14 description TEXT NOT NULL,
15 PRIMARY KEY (process_id, timestamp),
16 FOREIGN KEY (process_id) REFERENCES processes(id)
18 CREATE TABLE process_efforts (
19 process_id INTEGER NOT NULL,
20 timestamp TEXT NOT NULL,
22 PRIMARY KEY (process_id, timestamp),
23 FOREIGN KEY (process_id) REFERENCES processes(id)
25 CREATE TABLE process_titles (
26 process_id INTEGER NOT NULL,
27 timestamp TEXT NOT NULL,
29 PRIMARY KEY (process_id, timestamp),
30 FOREIGN KEY (process_id) REFERENCES processes(id)
32 CREATE TABLE processes (
33 id INTEGER PRIMARY KEY