Groups
MAIL_ARCHIVE
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | BLOB | 4000 | Y | |||
| 3 | SUBJECT | VARCHAR2 | 4000 | Y | ||
| 4 | FROM_ADDRESS | VARCHAR2 | 128 | Y | ||
| 5 | KEYWORDS | VARCHAR2 | 512 | Y | ||
| 6 | CONTENT_TYPE | VARCHAR2 | 128 | Y | ||
| 7 | DESCRIPTION | VARCHAR2 | 128 | Y | ||
| 8 | DISPOSITION | VARCHAR2 | 128 | Y | ||
| 9 | RECEIVED_DATE | DATE | 7 | Y | ||
| 10 | SENT_DATE | DATE | 7 | Y | ||
| 11 | REPLY_TO | VARCHAR2 | 512 | Y | ||
| 12 | RECIPIENTS | VARCHAR2 | 512 | Y | ||
| 13 | HEADERS | VARCHAR2 | 512 | Y | ||
| 14 | RECIPIENTS_CC | VARCHAR2 | 512 | Y | ||
| 15 | RECIPIENTS_BCC | VARCHAR2 | 512 | Y | ||
| 16 | PLAIN_TEXT_BODY | VARCHAR2 | 4000 | Y |