messages


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
imapids.message fk_imapids_message N
messagereads.message fk_messagereads_message C
messages.reference fk_messages_reference N

Message ID
owneruser int4 10 √ null
users.ID fk_messages_owneruser C

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
ownergroup int4 10 √ null
groups.ID fk_messages_ownergroup C

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
creator int4 10 √ null
users.ID fk_messages_creator N

Creator user ID (defaults to authenticated user on creation)
creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)
lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
mailserver int4 10 √ null
mailservers.ID fk_messages_mailserver N

Mail server ID
ticket int4 10 √ null
tickets.ID fk_messages_ticket N

Ticket ID; is mutually exclusive to opportunity
opportunity int4 10 √ null
opportunities.ID fk_messages_opportunity N

Opportunity ID; is mutually exclusive to ticket
mailinglist int4 10 √ null
mailinglists.ID fk_messages_mailinglist N

Mailing list ID
reference int4 10 √ null
messages.ID fk_messages_reference N

Reference message (reply-to) ID; must be distinct from ID
binfile int4 10 √ null
mailbox int2 5 0

Type (0=INBOX, 1=DRAFTS, 2=SENT, 3=TEMPLATES, 4=MAILINGS, 5=ARCHIVE, 6=TRASH, 7=JUNK)
date int8 19 date_part('epoch'::text, now())

Designated date and time as a Unix time stamp (defaults to current date and time on creation)
subject text 2147483647 ''::text

Subject
sender text 2147483647 ''::text

Sender name and e-mail address
sender_email text 2147483647 ''::text

Sender e-mail address
sender_name text 2147483647 ''::text

Sender name
to text 2147483647 ''::text

All regular recipient names and e-mail addresses
to_email text 2147483647 ''::text

First regular recipient e-mail address
to_name text 2147483647 ''::text

First regular recipient name
to_count int4 10 0

Number of regular recipients
cc text 2147483647 ''::text

All carbon copy recipient names and e-mail addresses
bcc text 2147483647 ''::text

All blind carbon copy recipient names and e-mail addresses
contenttype text 2147483647 ''::text

Content MIME type (RFC 2045)
size int4 10 0

Size in bytes
text text 2147483647 ''::text

Plain text version of content
senddate int8 19 √ null

Scheduled send date and time as a Unix time stamp
senderror text 2147483647 ''::text

Last error message from failure to send

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_messages Primary key Asc ID
fk_messages_mailinglist Performance Asc mailinglist
fk_messages_mailserver Performance Asc mailserver
fk_messages_opportunity Performance Asc opportunity
fk_messages_reference Performance Asc reference
fk_messages_ticket Performance Asc ticket
i_messages_date_ID Performance Desc/Desc date + ID
i_messages_mailbox Performance Asc mailbox
i_messages_noowner Performance Asc ownergroup
i_messages_owner Performance Asc/Asc owneruser + ownergroup
s_messages Performance Asc/Asc/Asc subject + sender + to

Relationships

Close relationships within degrees of separation