Reference > Database > WebSphere Commerce database tables > M

WebSphere Commerce database table: MSGMEMREL

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

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... 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... 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
SQL100520030356840	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

• Auction customer interaction data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search