Message Table

The Message Table (Message_tb) contains a record for every message in the system.

Table 1. Message Table field information
Field Name Type Size Use
MessageId number (long) 4 Identifier of the message.
MailboxId number (long) 4 Identifier of the mailbox.
FolderId number (long) 4 Identifier of the folder where the message resides. Possible folder:
  • 1 = InBox
  • 2 = OutBox
  • 3 = Trash
  • 4 = Spooler
SenderId number (long) 4 Identifier of the message sender.
SenderEMailAddr string 125 E-mail address of the message sender.
SentRepresenting string 125 Name of the person (if any) for which the message is sent.
ReceiverType number (long) 4 Type of receiver (such as TO, CC, or BCC).
ReceiverId number (long) 4 Identifier of the message receiver.
ReceiverGateway EMailAddr string 125 Gateway e-mail address of the receiver.
Subject string 125 Subject of the message.
ContentType string 125 Content type of the message.
ContentSubType string 125 Content subtype of the message.
CreationTime datetime (for SQL)

DATE (for Oracle)

 varies by DBMS Time the message was created.
SubmissionTime datetime (for SQL)

DATE (for Oracle)

 varies by DBMS Time the message was submitted.
SentTime datetime (for SQL)

DATE (for Oracle)

 varies by DBMS Time the message was sent.
OriginalId number (long) 4 Identifier of the message for which this message was copied.
OriginalFolderId number (long) 4 The folder this message was in before it was moved to the trash. Possible folder:
  • 1 = InBox
  • 2 = OutBox
  • 3 = Trash
  • 4 = Spooler
Flags number (long) 4 Attributes of the message.
Status number (long) 4 Status of the message. Possible status:
  • 1 = Ready to Send
  • 2 = Incomplete
  • 3 = Queued
  • 4 = Sending
  • 5 = InGateway
  • 6 = Sent
  • 7 = Read
  • 8 = Unread
  • 9 = Deleted
  • 10= SEND_FAILED
  • 11= DELIVERED
  • 12= PICKED_UP
  • 13= SENT_THIRD_PARTY
  • 14= DELIVERY_FAILED
SessionId string 125 Session identifier.
SeriesId string 125 Series identifier.