dbo.emails_sent
| Documentation | CRM |
| Schema | dbo |
| Name | emails_sent |
Log of emails sent from CRM.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Sensitive | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | email_id | int | Identity | Row ID | |||||
| Row ID Identity |
|||||||||
| 2 | to | nvarchar(500) | To field (emails, names) | Y | |||||
| To field (emails, names) Sensitive: Y |
|||||||||
| 3 | cc | nvarchar(500) | CC field (emails, names) | Y | |||||
| CC field (emails, names) Sensitive: Y |
|||||||||
| 4 | from | nvarchar(500) | From email address | Y | |||||
| From email address Sensitive: Y |
|||||||||
| 5 | from_display | nvarchar(500) | From display name | Y | |||||
| From display name Sensitive: Y |
|||||||||
| 6 | title | nvarchar(500) | Email subject | Y | |||||
| Email subject Sensitive: Y |
|||||||||
| 7 | message | ntext | Email body (HTML) | Y | |||||
| Email body (HTML) Sensitive: Y |
|||||||||
| 8 | is_successful | bit | Was sent successful - 1: yes, 0: failed. | ||||||
| Was sent successful - 1: yes, 0: failed. |
|||||||||
| 9 | error_message | ntext | Error message from server | ||||||
| Error message from server |
|||||||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_emails_sent_tab | email_id | ||
Exported: 2019-02-04 23:17, Last imported: 2018-02-28 01:29