WebSphere Commerce database table: MSGMEMREL

This table describes the relationship between a message and a member.

Column Descriptions
Column Name Column Type Description
MESSAGE_ID BIGINT NOT NULL Message ID.
MEMBER_ID BIGINT NOT NULL The ID of the user who will receive the message.
STATUS CHAR(4) NOT NULL Message status. Valid values are as follows:

  • N=new message not read by recipient

  • O=opened and the recipient has read the message

  • D=deleted and the recipient has deleted the message

SENDSTAT CHAR(4) Send status. Valid values are as follows:

  • N=not sent by e-mail

  • S=sent by email

OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235215400 MESSAGE_ID+MEMBER_ID Primary Key
I0000161 STATUS Non-Unique Index
I0000162 SENDSTAT Non-Unique Index
I0000623 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_464 MEMBER_ID MEMBER MEMBER_ID Cascade
F_463 MESSAGE_ID MESSAGE MESSAGE_ID Cascade
Related reference