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 |