db_message

Details of emails sent and received

ColumnTypeReferencesComments
idInteger Primary key
guidString  
vdb_idInteger  
summaryString Subject of the email
detailString Body of the email
creator_idIntegerdb_person.idCreator ID
senderString Sender email address
to_recipientsString To recipient email addresses
cc_recipientsString Cc recipient email addresses
bcc_recipientsString Bcc recipient email addresses
reply_toString Reply to email address
is_htmlBoolean (t or f) Whether this is HTML email
task_idIntegerdb_task.id 
discussion_idIntegerdb_discussion.id 
createdDate Date this mail was created
parent_idIntegerdb_message.idID of this email messsage this was a reply to
root_idIntegerdb_message.idRoot ID of the email thread
num_attachmentsInteger Number of attachments