Reference > Database > WebSphere Commerce database tables > F


WebSphere Commerce database table: FORUMMSG

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

Column Name Column Type Description
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...

  • A=active

  • D=deleted

VIEWSTATUS CHAR(4) View status. Valid values are...

  • 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...

  • 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.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030338020 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
I0001258 FORUM_ID Non-Unique Index
I0001294 PARENTMSG_ID Non-Unique Index
I0001295 ROOTMSG_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_350 PARENTMSG_ID FORUMMSG MSG_ID Cascade
F_351 ROOTMSG_ID FORUMMSG MSG_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search