messages

Module: messages

Email messages with threading, attachments, and ticket linking.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Message ID
fork forks.ID	integer			Fork ID (`null` for base module)
owneruser users.ID	integer			Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroup groups.ID	integer			Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
mailserver mailservers.ID	integer			Mail server ID
ticket tickets.ID	integer			Ticket ID; is mutually exclusive to `opportunity`
opportunity opportunities.ID	integer			Opportunity ID; is mutually exclusive to `ticket`
mailinglist mailinglists.ID	integer			Mailing list ID
reference messages.ID	integer			Reference message (reply-to) ID; must be distinct from `ID`
binfile binfiles.ID	integer			Binary file ID; is read-only (not for `PUT` or `PATCH`)
mailbox	smallint		0	Type (`0`=INBOX, `1`=DRAFTS, `2`=SENT, `3`=TEMPLATES, `4`=MAILINGS, `5`=ARCHIVE, `6`=TRASH, `7`=JUNK)
verified	smallint		0	Verified sender e-mail address
date	bigint		date_part('epoch', now())	Designated date and time as a Unix timestamp (defaults to current date and time on creation)
subject	text		''	Subject
sender	text		''	Sender name and e-mail address
sender_email	text		''	Sender e-mail address
sender_name	text		''	Sender name
to	text		''	All regular recipient names and e-mail addresses
to_email	text		''	First regular recipient e-mail address
to_name	text		''	First regular recipient name
to_count	integer		0	Number of regular recipients
cc	text		''	All carbon copy recipient names and e-mail addresses
bcc	text		''	All blind carbon copy recipient names and e-mail addresses
contenttype	text		''	Content MIME type (RFC 2045)
text	text		''	Plain text version of content
attachments	text[]			Array-encoded attachments (filenames)
senddate	bigint			Scheduled send date and time as a Unix timestamp
senderror	text		''	Last error message from failure to send
messageid	text		''

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_messages_binfile					btree	binfile
fk_messages_fork					gin	fork
fk_messages_mailinglist					gin	mailinglist
fk_messages_mailserver					gin	mailserver
fk_messages_opportunity					btree	opportunity
fk_messages_ownergroup					gin	ownergroup
fk_messages_owneruser					gin	owneruser
fk_messages_reference					btree	reference
fk_messages_ticket					btree	ticket
i_messages_inbox_date					btree	date
i_messages_messageid					btree	messageid
i_messages_nofork					gin	fork
i_messages_noowner					gin	ownergroup
i_messages_regular_date					btree	date
i_messages_sendmail					btree	mailserver
i_messages_trash_date					btree	date
pk_messages					btree	ID
s_messages_sender					gin	sender
s_messages_subject					gin	subject
s_messages_to					gin	to

Name	Type
c_messages_association	check
c_messages_owner	check
c_messages_reference	check
c_messages_senderror	check
dc_messages_bcc	check
dc_messages_cc	check
dc_messages_contenttype	check
dc_messages_mailbox	check
dc_messages_sender	check
dc_messages_sender_email	check
dc_messages_sender_name	check
dc_messages_senderror	check
dc_messages_subject	check
dc_messages_text	check
dc_messages_to	check
dc_messages_to_count	check
dc_messages_to_email	check
dc_messages_to_name	check
fk_messages_binfile	foreign_key
fk_messages_fork	foreign_key
fk_messages_mailinglist	foreign_key
fk_messages_mailserver	foreign_key
fk_messages_opportunity	foreign_key
fk_messages_ownergroup	foreign_key
fk_messages_owneruser	foreign_key
fk_messages_reference	foreign_key
fk_messages_ticket	foreign_key
pk_messages	primary_key

Loading...