MESSAGE

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.
MSGTYPEINTEGERReserved for IBM internal use.
SUBJECTVARCHAR (254)Reserved for IBM internal use.
POSTTIMETIMESTAMPReserved for IBM internal use.
CONTENTCLOB (1000000)Reserved for IBM internal use.
MSGPARAM1VARCHAR (254)Reserved for IBM internal use.
MSGPARAM2VARCHAR (254)Reserved for IBM internal use.
MSGPARAM3VARCHAR (254)Reserved for IBM internal use.
DELAYTIMESTAMPReserved for IBM internal use.
BASETIMESTAMPReserved for IBM internal use.
TARGET_IDBIGINTReserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MESSAGE_IDPrimary Key
I0000156MSGTYPENon-Unique Index
I0000157DELAYNon-Unique Index
I0000158BASENon-Unique Index
I0000159TARGET_IDNon-Unique Index
I0000619MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_459MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_463MESSAGE_IDMSGMEMRELMESSAGE_IDCascade