db_message

Details of emails sent and received

Column	Type	References	Comments
id	Integer		Primary key
guid	String
vdb_id	Integer
summary	String		Subject of the email
detail	String		Body of the email
creator_id	Integer	db_person.id	Creator ID
sender	String		Sender email address
to_recipients	String		To recipient email addresses
cc_recipients	String		Cc recipient email addresses
bcc_recipients	String		Bcc recipient email addresses
reply_to	String		Reply to email address
is_html	Boolean (t or f)		Whether this is HTML email
task_id	Integer	db_task.id
discussion_id	Integer	db_discussion.id
created	Date		Date this mail was created
parent_id	Integer	db_message.id	ID of this email messsage this was a reply to
root_id	Integer	db_message.id	Root ID of the email thread
num_attachments	Integer		Number of attachments