Groups
MAIL_MESSAGE
| Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | 'Primary' key | |
STATUS_ID | NUMBER | 22 | Y | Email status: 0-ready, 1-sent, 9 error | |
CREATE_DATE | DATE | 7 | Y | Date of creating email | |
SENT_DATE | DATE | 7 | Y | Date of sending email | |
TO_ADDRESSES | VARCHAR2 | 1000 | Y | Email destination address | |
CC_ADDRESSES | VARCHAR2 | 1000 | Y | CC destination address | |
BCC_ADDRESSES | VARCHAR2 | 1000 | Y | BCC destination address | |
SUBJECT | VARCHAR2 | 500 | Y | Email subject | |
MESSAGE | VARCHAR2 | 4000 | Y | Email text | |
FROM_NAME | VARCHAR2 | 100 | Y | Email sender | |
FROM_EMAIL | VARCHAR2 | 100 | Y | Email sender address | |
TYPE_ID | NUMBER | 22 | Y | Type of email, 0-plain text, 1-sent | |
ERROR_MESSAGE | VARCHAR2 | 1000 | Y | Error message in case of send failure | |
PRIORITY | VARCHAR2 | 2 | Y | Send priority | |
MARKETING_CAMPAIGN_ID | NUMBER | 22 | Y | References MARKETING_CAMPAIGN table | |
SEND_FROM_DATE | DATE | 7 | Y | Date from which mail is ready for sending | |
MAIL_DELETION_PROFILE_ID | NUMBER | 22 | Y | References MAIL_DELETION_PROFILE table | |
FROM_USER | VARCHAR2 | 50 | Y | User creating the mail | |
MAILTEMPLATE_ID | NUMBER | 22 | Y | Mail template used | |
GATEWAY_KEY | VARCHAR2 | 400 | Y | ||
| OBJECT_ID | NUMBER | With v 9.8 | |||
| OBJECT_CLASS | VARCHAR2 | 100 | With v 9.8 |
Contains detailed information about all outgoing mail in the system