Lines Matching refs:id

2   id                     INTEGER NOT NULL PRIMARY KEY,
33   thread_id       INTEGER NOT NULL REFERENCES thread (id),
50   id                     INTEGER NOT NULL PRIMARY KEY,
52   thread_id              INTEGER NOT NULL REFERENCES thread (id),
71       JOIN thread ON thread_comment.thread_id = thread.id;
77   id         INTEGER     NOT NULL PRIMARY KEY,
101   WHERE id = new.label_id;
110   WHERE id = old.label_id;
119   WHERE id = old.label_id;
123   WHERE id = new.label_id;
127   id         INTEGER     NOT NULL PRIMARY KEY,
137   id                     INTEGER NOT NULL PRIMARY KEY,
163   thread_id              INTEGER REFERENCES thread (id), --may be null
164   thread_comment_id      INTEGER REFERENCES thread_comment (id), --may be null
165   task_program_id        INTEGER REFERENCES task_program (id) --may be null
181   WHERE id = new.thread_id;
191   WHERE id = new.thread_id;
200   WHERE id = old.thread_id;
203   WHERE id = new.thread_id;
213   WHERE id = old.thread_id;
223   WHERE id = new.thread_id;
233   WHERE id = new.thread_id;
243   WHERE id = old.thread_id;
253   WHERE id = old.thread_id;
256   WHERE id = new.thread_id;
267   WHERE id = new.thread_comment_id;
276   WHERE id = old.thread_comment_id;
280   WHERE id = new.thread_comment_id;
292   WHERE id = new.task_program_id;
301   WHERE id = old.task_program_id;
310   WHERE id = old.task_program_id;
314   WHERE id = new.task_program_id;
319   task_id       INTEGER NOT NULL REFERENCES thread (id),
335   id                     INTEGER NOT NULL PRIMARY KEY,
337   task_id                INTEGER NOT NULL REFERENCES task (id),
369       LEFT JOIN task_program ON task.task_program_id = task_program.id
370       LEFT JOIN thread ON task.thread_id = thread.id;
374     SELECT thread.id, thread.original_poster, thread.coordinator, thread.closed_by,
379       label.id AS label_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
386       LEFT JOIN label ON label.id = thread_label.label_id;