The thread_members table

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 info@aox.org.

Relevant links

About this page

Last modified: 2010-11-19
Location: aox.org/db/thread_members