Details of emails sent and received
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| summary | String | Subject of the email | |
| detail | String | Body of the email | |
| creator_id | Integer | db_user.id | Creator ID |
| original_message | Integer | db_document.id | If this mail was imported or read from an email server, then the ID of the document that stores this file |
| is_parsed_ok | Boolean (t or f) | If this mail was read from an email server, whether it was parsed without any problems | |
| 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 | |
| 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 |