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 |