Lines Matching defs: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