This table is deprecated and is provided for
backward compatibility only.
Column Descriptions:
| Name | Type | Description |
| MSG_ID | BIGINT NOT NULL | Reserved for IBM internal use. |
| FORUM_ID | BIGINT NOT NULL | Reserved for IBM internal use. |
| POSTER_ID | BIGINT NOT NULL | Reserved for IBM internal use. |
| ROOTMSG_ID | BIGINT | Reserved for IBM internal use. |
| PARENTMSG_ID | BIGINT | Reserved for IBM internal use. |
| POSTTIME | TIMESTAMP | Reserved for IBM internal use. |
| TARGET_ID | BIGINT | Reserved for IBM internal use. |
| MSGSTATUS | CHAR (4) | Reserved for IBM internal use. |
| VIEWSTATUS | CHAR (4) | Reserved for IBM internal use. |
| MSGSUBJ | VARCHAR (254) | Reserved for IBM internal use. |
| MSGBODY | VARCHAR (4000) | Reserved for IBM internal use. |
| ACTION | CHAR (4) | Reserved for IBM internal use. |
| ACTREMARK | VARCHAR (4000) | Reserved for IBM internal use. |
| FIELD1 | BIGINT | Reserved for IBM internal use. |
| FIELD2 | BIGINT | Reserved for IBM internal use. |
| FIELD3 | BIGINT | Reserved for IBM internal use. |
| OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | 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 |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_350 | MSG_ID | FORUMMSG | PARENTMSG_ID | Cascade |
| F_351 | MSG_ID | FORUMMSG | ROOTMSG_ID | Cascade |