Recipient Table
The Recipient Table (Recipient_tb) associates messages with one or more recipients (mailboxes or distribution lists).
| Field Name | Type | Size | Use |
|---|---|---|---|
| MessageId | number (long) | 4 | Identifier of the message. |
| RecipientType | number (long) | 4 | Type of recipient (such as TO, CC, or BCC). |
| RecipientId | number (long) | 4 | Identifier of the recipient. |
| RecipientGateway EMailAddr | string | 125 | The gateway e-mail address of the recipient. |
| AddressBookType | number (long) | 4 | Address book type (such as mailbox or distribution list). |
| RecipientStatus | number (long) | 4 | Message status for each message recipient. |
| SentTime | datetime (for SQL) DATE (for Oracle) |
varies by DBMS | The time when the message reached the recipient. |