Database Table: MSGMEMREL

This table describes the message and member relationship.

Column Name Column Type Column Description
MEMBER_ID BIGINT
NOT NULL
The ID of the user who will receive the message.
MESSAGE_ID BIGINT
NOT NULL
Message ID.
SENDSTAT CHARACTER (4)
NULL
Send status. Valid values: N=not sent by email, S=sent by email.
STATUS CHARACTER (4)
NOT NULL
Message status. Valid values: N=new message not read by recipient, O=opened, recipient has read the message, D=delete, recipient has deleted the message.
Indexes:
Index Name Indexed Column Names Index Type
I0000161 STATUS Non-Unique Index
I0000162 SENDSTAT Non-Unique Index
SQL030416035005860 MESSAGE_ID, MEMBER_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_463 MESSAGE_ID MESSAGE MESSAGE_ID Cascade
F_464 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable