1 CREATE TABLE process_blockers (
2 process INTEGER NOT NULL,
3 condition INTEGER NOT NULL,
4 PRIMARY KEY (process, condition),
5 FOREIGN KEY (process) REFERENCES processes(id),
6 FOREIGN KEY (condition) REFERENCES conditions(id)
8 CREATE TABLE todo_blockers (
10 condition INTEGER NOT NULL,
11 PRIMARY KEY (todo, condition),
12 FOREIGN KEY (todo) REFERENCES todos(id),
13 FOREIGN KEY (condition) REFERENCES conditions(id)