MESSAGE

Deprecated. Provided for backward compatibility only.

Column Descriptions:

Name	Type	Description
MESSAGE_ID	BIGINT NOT NULL	Reserved for IBM internal use.
MEMBER_ID	BIGINT NOT NULL	Reserved for IBM internal use.
MSGTYPE	INTEGER	Reserved for IBM internal use.
SUBJECT	VARCHAR (254)	Reserved for IBM internal use.
POSTTIME	TIMESTAMP	Reserved for IBM internal use.
CONTENT	CLOB (1000000)	Reserved for IBM internal use.
MSGPARAM1	VARCHAR (254)	Reserved for IBM internal use.
MSGPARAM2	VARCHAR (254)	Reserved for IBM internal use.
MSGPARAM3	VARCHAR (254)	Reserved for IBM internal use.
DELAY	TIMESTAMP	Reserved for IBM internal use.
BASE	TIMESTAMP	Reserved for IBM internal use.
TARGET_ID	BIGINT	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	MESSAGE_ID	Primary Key
I0000156	MSGTYPE	Non-Unique Index
I0000157	DELAY	Non-Unique Index
I0000158	BASE	Non-Unique Index
I0000159	TARGET_ID	Non-Unique Index
I0000619	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_459	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_463	MESSAGE_ID	MSGMEMREL	MESSAGE_ID	Cascade