| 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 272,041 rows at Wed Oct 20 01:06 IST 2021
|
