The messages table

This table contains one row for each distinct message stored.

If a message exists in more than one mailbox, there will be more than one row in mailbox_messages rows, all of which refer to just one row in messages.

id stores the message's database id. It is used to refer to this message from the many tables that hold the message contents, such as address_fields, header_fields and (via part_numbers) bodyparts.

rfc822size is an optimisation. It is the size of the message in RFC 822 format. It could be computed when needed, but IMAP clients ask for it often and computing it is slow. 


create table messages (
    -- Grant: select, insert
    id          serial primary key,
    rfc822size  integer
);

The messages table was introduced in version 0.93.

In case of questions, please write to info@oryx.com.

Relevant links

About this page

Last modified: 2008-08-25
Location: aox.org/db/messages