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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000161 | STATUS | Non-Unique Index |
I0000162 | SENDSTAT | Non-Unique Index |
SQL030416035005860 | MESSAGE_ID, MEMBER_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|