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