Lines Matching refs:task
136 CREATE TABLE task (
141 closed_by TEXT NULL, -- who closed the task
169 ON task (thread_id, thread_comment_id);
172 ON task(task_program_id);
176 ON task
186 ON task
196 ON task
208 ON task
218 ON task
228 ON task
238 ON task
248 ON task
263 ON task
272 ON task
288 ON task
297 ON task
306 ON task
337 task_id INTEGER NOT NULL REFERENCES task (id),
361 task.*,
364 CASE WHEN task.state = 'done' THEN NULL
365 WHEN task.plan_date >= date('now', '+1 month') THEN '2'
366 WHEN task.plan_date >= date('now') THEN '1'
368 FROM task
369 LEFT JOIN task_program ON task.task_program_id = task_program.id
370 LEFT JOIN thread ON task.thread_id = thread.id;