Lines Matching refs:thread_id
33 thread_id INTEGER NOT NULL REFERENCES thread (id),
46 PRIMARY KEY (thread_id, user_id)
52 thread_id INTEGER NOT NULL REFERENCES thread (id),
71 JOIN thread ON thread_comment.thread_id = thread.id;
74 ON thread_comment (thread_id);
90 thread_id INTEGER NOT NULL,
92 PRIMARY KEY (thread_id, label_id)
163 thread_id INTEGER REFERENCES thread (id), --may be null
169 ON task (thread_id, thread_comment_id);
177 WHEN new.thread_id IS NOT NULL
181 WHERE id = new.thread_id;
187 WHEN new.thread_id IS NOT NULL AND new.cost IS NOT NULL
191 WHERE id = new.thread_id;
195 UPDATE OF thread_id
200 WHERE id = old.thread_id;
203 WHERE id = new.thread_id;
207 UPDATE OF thread_id, cost
213 WHERE id = old.thread_id;
217 UPDATE OF thread_id, cost
223 WHERE id = new.thread_id;
227 UPDATE OF thread_id, state
233 WHERE id = new.thread_id;
237 UPDATE OF thread_id, state
243 WHERE id = old.thread_id;
247 UPDATE OF thread_id, state
253 WHERE id = old.thread_id;
256 WHERE id = new.thread_id;
370 LEFT JOIN thread ON task.thread_id = thread.id;
381 (SELECT MIN(priority) FROM task_view WHERE task_view.thread_id = thread.id) AS priority,
385 LEFT JOIN thread_label ON thread.id = thread_label.thread_id