This table contains forum messages sent between an administrator and a customer.
Column Description(s):
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 as follows:
|
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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_350 |
PARENTMSG_ID |
FORUMMSG |
MSG_ID |
Cascade |
F_351 |
ROOTMSG_ID |
FORUMMSG |
MSG_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.