Details of emails sent and received
| Column | Type | References | Comments | |
| id | IntegerInteger | Primary Primary key | ||
| guid | StringString | |||
| vdb_id | IntegerInteger | |||
| summary | StringString | Subject Subject of the email | ||
| detail | StringString | Body Body of the email | ||
| creator_id | IntegerInteger | db_person.id | Creator ID | |
| is_parsed_ok | Boolean (t or f) | If this mail was read from an email server, whether it was parsed without any problems | ||
| sender | StringCreator ID | |||
| sender | String | Sender Sender email address | ||
| to_recipients | StringString | To To recipient email addresses | ||
| cc_recipients | StringString | Cc Cc recipient email addresses | ||
| bcc_recipients | StringString | Bcc Bcc recipient email addresses | ||
| reply_to | StringString | Reply Reply to email address | ||
| is_html | Boolean Boolean (t or f) | Whether Whether this is HTML email | ||
| task_id | IntegerInteger | db_task.id | ||
| discussion_id | Integer | Integer | db_discussion.id | |
| created | DateDate | Date Date this mail was created | ||
| parent_id | IntegerInteger | db_message.id | ID ID of this email messsage this was a reply to | |
| root_id | IntegerInteger | db_message.id | RootRoot ID of the email thread | |
| num_attachments | IntegerInteger | Number | Number of attachments |