The field_names table

All header field names are stored in field_names.

The name column stores the field name. The name is stored in header-cased form (Reply-To, not Reply-to or reply-to) and there is no trailing colon). header_fields and other tables refer to this one.

The Archiveopteryx installer initialises this table with some common field names, such as From, To, Date and Subject. Entries are added to the table as messages are stored in the database.

By convention, anyone who inserts rows into field_names also sends NOTIFY field_names_extended in the same transaction.

create table field_names ( -- Grant: select, insert id serial primary key, name text unique );

The field_names table was introduced in version 0.93.

In case of questions, please write to info@aox.org.

Relevant links

About this page

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