MSGMEMREL

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
MESSAGE_IDBIGINT NOT NULLReserved for IBM internal use.
MEMBER_IDBIGINT NOT NULLReserved for IBM internal use.
STATUSCHAR (4) NOT NULLReserved for IBM internal use.
SENDSTATCHAR (4)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MESSAGE_ID+MEMBER_IDPrimary Key
I0000161STATUSNon-Unique Index
I0000162SENDSTATNon-Unique Index
I0000623MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_463MESSAGE_IDMESSAGEMESSAGE_IDCascade
F_464MEMBER_IDMEMBERMEMBER_IDCascade