MSGMEMREL

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

Column Descriptions:

NameTypeDescription
MESSAGE_IDBIGINT NOT NULLReserved for HCL internal use.
MEMBER_IDBIGINT NOT NULLReserved for HCL internal use.
STATUSCHAR (4) NOT NULLReserved for HCL internal use.
SENDSTATCHAR (4)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL 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