WebSphere Commerce database table: FORUMMSG

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


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

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_350 PARENTMSG_ID FORUMMSG MSG_ID Cascade
F_351 ROOTMSG_ID FORUMMSG MSG_ID Cascade

Feedback