messages

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

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_creator	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...