{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
Col#
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
'Primary' key
2
STATUS_ID
NUMBER
22
Y
Email status: 0-ready, 1-sent, 9 error
3
CREATE_DATE
DATE
7
Y
Date of creating email4
SENT_DATE
DATE
7
Y
Date of sending email5
TO_ADDRESSES
VARCHAR2
1000
Y
Email destination address
6
CC_ADDRESSES
VARCHAR2
1000
Y
CC destination address
7
BCC_ADDRESSES
VARCHAR2
1000
Y
BCC destination address
8
SUBJECT
VARCHAR2
500
Y
Email subject
9
MESSAGE
VARCHAR2
4000
Y
Email text
10
FROM_NAME
VARCHAR2
100
Y
Email sender11
FROM_EMAIL
VARCHAR2
100
Y
Email sender address
12
TYPE_ID
NUMBER
22
Y
Type of email,
0-plain text, 1-sent
13
ERROR_MESSAGE
VARCHAR2
1000
Y
Error message in case of send failure
14
PRIORITY
VARCHAR2
2
Y
Send priority15
MARKETING_CAMPAIGN_ID
NUMBER
22
Y
References MARKETING_CAMPAIGN table
16
SEND_FROM_DATE
DATE
7
Y
Date from which mail is ready for sending
17
MAIL_DELETION_PROFILE_ID
NUMBER
22
Y
References MAIL_DELETION_PROFILE table
18
FROM_USER
VARCHAR2
50
Y
User creating the mail
19
MAILTEMPLATE_ID
NUMBER
22
Y
Mail template used20
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