{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
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
Column
width
33%
Contains detailed information about all outgoing mail in the system