{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
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
DELETABLE_FROM_DATE
DATE
7
Y
Date from which mail can be deleted
FROM_USER
VARCHAR2
50
Y
User creating the mail
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