Database Table: FORUMMSG

This table contains forum messages sent between the administrator and a customer.

Column Name Column Type Column Description
ACTION CHARACTER (4)
NULL
Action performed by the administrator. Valid values: N=no action, A=administrator has responded, S=message changed to public.
ACTREMARK VARCHAR (4000)
NULL
Reserved for IBM internal use.
FIELD1 BIGINT
NULL
Customizable.
FIELD2 BIGINT
NULL
Customizable.
FIELD3 BIGINT
NULL
Customizable.
FORUM_ID BIGINT
NOT NULL
Indicates to which forum this message belongs.
MSGBODY VARCHAR (4000)
NULL
Message content.
MSGSTATUS CHARACTER (4)
NULL
Message status. Valid values: A=active, D=deleted.
MSGSUBJ VARCHAR (254)
NULL
Message subject.
MSG_ID BIGINT
NOT NULL
Forum message ID. Primary key to this table.
PARENTMSG_ID BIGINT
NULL
Parent message ID. The ID of the parent message.
POSTER_ID BIGINT
NOT NULL
ID of the user who posted the message.
POSTTIME TIMESTAMP
NULL
Date and time of the message.
ROOTMSG_ID BIGINT
NULL
ID of the root of the message chain.
TARGET_ID BIGINT
NULL
If this message relates to an auction, this field will contain an auction ID.
VIEWSTATUS CHARACTER (4)
NULL
View status. Valid values: P=message is public, I=message is private.
Indexes:
Index Name Indexed Column Names Index Type
I0000111 POSTER_ID Non-Unique Index
I0000112 TARGET_ID Non-Unique Index
I0000113 MSGSTATUS Non-Unique Index
I0000114 VIEWSTATUS Non-Unique Index
SQL030416034936770 MSG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_350 PARENTMSG_ID FORUMMSG MSG_ID Cascade
F_351 ROOTMSG_ID FORUMMSG MSG_ID Cascade
F_352 FORUM_ID FORUM FORUM_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_350 MSG_ID FORUMMSG PARENTMSG_ID Cascade
F_351 MSG_ID FORUMMSG ROOTMSG_ID Cascade