1 2 3 4 5
CREATE TABLE mailthreadsubjects ( threadid INTEGER, subjectid INTEGER, FOREIGN KEY (threadid) REFERENCES mailthreads(id), FOREIGN KEY (subjectid) REFERENCES mailsubjects(id));