Groups
MAIL_QUEUE
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | MAIL_ARCHIVE_ID | NUMBER | 22 | Y | ||
| 3 | REPLY_MAIL_ARCHIVE_ID | NUMBER | 22 | Y | ||
| 4 | CATEGORY_ID | NUMBER | 22 | Y | ||
| 5 | OPERATOR_ID | NUMBER | 22 | Y | ||
| 6 | TRACKING_ID | VARCHAR2 | 20 | Y | ||
| 7 | USERS_ID | NUMBER | 22 | Y | ||
| 8 | SERVICE_ID | NUMBER | 22 | Y | ||
| 9 | BILLINGGROUP_ID | NUMBER | 22 | Y | ||
| 10 | STATUS_ID | NUMBER | 22 | Y | ||
| 11 | CREATE_DATE | DATE | 7 | Y | ||
| 12 | REPLY_DATE | DATE | 7 | Y | ||
| 13 | START_REPLY_DATE | DATE | 7 | Y | ||
| 14 | ACCOUNT_ID | NUMBER | 22 | Y | ||
| 15 | OPEN_STATUS | NUMBER | 22 | Y | ||
| 16 | UNREAD | NUMBER | 22 | Y | ||
| 17 | BRAND_ID | NUMBER | 22 | Y | ||
| 18 | STATUS_DATE | DATE | 7 | Y |