{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_SENT
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 email
4
SENT_DATE
DATE
7
Y
Date of sending email5
TO_ADDRESSES
VARCHAR2
1000
Y
Email destination address6
CC_ADDRESSES
VARCHAR2
1000
Y
CC destination address
7
BCC_ADDRESSES
VARCHAR2
1000
Y
BCC destination address
8
SUBJECT
VARCHAR2
500
Y
Email subject9
MESSAGE
VARCHAR2
4000
Y
Email text10
FROM_NAME
VARCHAR2
100
Y
Email sender
11
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 failure14
PRIORITY
VARCHAR2
2
Y
Send priority15
MARKETING_CAMPAIGN_ID
NUMBER
22
Y
References MARKETING_CAMPAIGN table
16
DELETABLE_FROM_DATE
DATE
7
Y
Date from which mail can be deleted
17
FROM_USER
VARCHAR2
50
Y
User creating the mail18
MAILTEMPLATE_ID
NUMBER
22
Y
Mail template used
OBJECT_ID
NUMBER
With v 9.8
OBJECT_CLASS
VARCHAR2
100
With v 9.8
Column
width
33%
Contains all email messages already sent by the system