jivePMessage Table

Container table for private message data.

Column Name Type Length Nullable Unicode Description
body text N/A true true The body of the private message.
creationDate bigint N/A false   The private message creation date.
folderID bigint N/A false   The ID of the folder the message lives in.
ownerID bigint N/A false   The user whose mailbox the private message is in. For example, the ownerID is different from the recipient ID when the message is a draft.
pMessageDate bigint N/A false   The private message modification date.
pMessageID bigint N/A false   Private message ID. Primary key.
readStatus smallint N/A false   The read status -- read or unread.
recipientID bigint N/A true   The user who received the private message.
senderID bigint N/A true   The user who sent the private message.
sentDate bigint N/A true   The private message sent date.
status int N/A false   The published status of the private message.
subject varchar 255 true true The subject of the private message.