The threads table

The threads table names a single thread. For the moment it only uses primitive subject-based threading, but we plan to extend it.

The existence of a row means that there is a thread about the specified text in the specified mailbox. Text is derived from a message's subject.

create table threads ( -- Grant: select, insert, update id serial primary key, mailbox integer not null references mailboxes(id), subject text, unique (mailbox, subject) );

The threads 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/threads