db_message
Details of emails sent and received
Column | Type | References | Comments |
---|---|---|---|
id | Integer | Â | Primary key |
guid | String | Â | Â |
vdb_id | Integer | Â | Â |
name | String | Â | Subject of the email |
description | 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 |