Thread_members stores message threading information persistently, so that Archiveopteryx doesn't have to recompute it all the time. It is a cache: if you delete all the rows in it, Archiveopteryx will recompute the data when it's needed and add the rows back.
The thread column refers to a thread and mailbox and uid name a message in this thread.
We expect to extend this table in the near future.
create table thread_members ( -- Grant: select, insert thread integer not null references threads(id), mailbox integer not null, uid integer not null, primary key (thread, mailbox, uid), foreign key (mailbox, uid) references mailbox_messages(mailbox, uid) on delete cascade );
The thread_members table was introduced in version 0.97.
In case of questions, please write to email@example.com.
Last modified: 2010-11-19