FORUMMSG

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

Column Descriptions:

NameTypeDescription
MSG_IDBIGINT NOT NULLReserved for HCL internal use.
FORUM_IDBIGINT NOT NULLReserved for HCL internal use.
POSTER_IDBIGINT NOT NULLReserved for HCL internal use.
ROOTMSG_IDBIGINTReserved for HCL internal use.
PARENTMSG_IDBIGINTReserved for HCL internal use.
POSTTIMETIMESTAMPReserved for HCL internal use.
TARGET_IDBIGINTReserved for HCL internal use.
MSGSTATUSCHAR (4)Reserved for HCL internal use.
VIEWSTATUSCHAR (4)Reserved for HCL internal use.
MSGSUBJVARCHAR (254)Reserved for HCL internal use.
MSGBODYVARCHAR (4000)Reserved for HCL internal use.
ACTIONCHAR (4)Reserved for HCL internal use.
ACTREMARKVARCHAR (4000)Reserved for HCL internal use.
FIELD1BIGINTReserved for HCL internal use.
FIELD2BIGINTReserved for HCL internal use.
FIELD3BIGINTReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MSG_IDPrimary Key
I0000111POSTER_IDNon-Unique Index
I0000112TARGET_IDNon-Unique Index
I0000113MSGSTATUSNon-Unique Index
I0000114VIEWSTATUSNon-Unique Index
I0001258FORUM_IDNon-Unique Index
I0001294PARENTMSG_IDNon-Unique Index
I0001295ROOTMSG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_350PARENTMSG_IDFORUMMSGMSG_IDCascade
F_351ROOTMSG_IDFORUMMSGMSG_IDCascade
F_352FORUM_IDFORUMFORUM_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_350MSG_IDFORUMMSGPARENTMSG_IDCascade
F_351MSG_IDFORUMMSGROOTMSG_IDCascade