Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
SMTPHOST |
varchar2 |
40 |
√ |
|
null |
|
|
SMTPPORT |
varchar2 |
40 |
√ |
|
null |
|
|
MAILAUTHENTICATIONFLAG |
varchar2 |
40 |
√ |
|
null |
|
|
MAILAUTHENTICATIONUSERNAME |
varchar2 |
100 |
√ |
|
null |
|
|
MAILAUTHENTICATIONPASSWORD |
varchar2 |
40 |
√ |
|
null |
|
|
FROMUSER |
varchar2 |
255 |
√ |
|
null |
|
|
TOUSER |
varchar2 |
4000 |
√ |
|
null |
|
|
CC |
varchar2 |
4000 |
√ |
|
null |
|
|
BCC |
varchar2 |
4000 |
√ |
|
null |
|
|
MESSAGE |
varchar2 |
4000 |
√ |
|
null |
|
|
SUBJECT |
varchar2 |
4000 |
√ |
|
null |
|
|
STATUS |
varchar2 |
4000 |
√ |
|
null |
|
|
ATTACHMENTS |
varchar2 |
4000 |
√ |
|
null |
|
|
SENT_AT |
date |
7 |
√ |
|
now |
|
|
MAILS_SENT_ID |
number |
22 |
|
|
|
|
|
MESSAGE_BLOB |
blob |
4000 |
√ |
|
null |
|
|
TO_STATE_ID |
number |
22 |
√ |
|
null |
|
|
INSTANCE_ID |
number |
22 |
√ |
|
null |
|
|
RESENT_AT |
date |
7 |
√ |
|
null |
|
|
RESEND_ATTEMPTS |
number |
22 |
√ |
|
null |
|
|
MIMEMESSAGE_FILE_ID |
number |
22 |
√ |
|
null |
|
|
STATUS_MESSAGE |
varchar2 |
4000 |
√ |
|
null |
|
|
PREV_CONVO_MAILS_SENT_IDZ |
varchar2 |
255 |
√ |
|
null |
|
|
PUBLIC_VISIBILITY |
varchar2 |
255 |
√ |
|
null |
|
|
Table contained 1,444,041 rows at Wed May 25 01:05 IST 2022
|