is_active BOOLEAN NOT NULL
);
CREATE TABLE days (
- date TEXT PRIMARY KEY,
+ id TEXT PRIMARY KEY,
comment TEXT NOT NULL
);
CREATE TABLE process_conditions (
FOREIGN KEY (condition) REFERENCES conditions(id)
);
CREATE TABLE process_steps (
- step_id INTEGER PRIMARY KEY,
+ id INTEGER PRIMARY KEY,
owner_id INTEGER NOT NULL,
step_process_id INTEGER NOT NULL,
parent_step_id INTEGER,
is_done BOOLEAN NOT NULL,
day TEXT NOT NULL,
FOREIGN KEY (process_id) REFERENCES processes(id),
- FOREIGN KEY (day) REFERENCES days(date)
+ FOREIGN KEY (day) REFERENCES days(id)
);