This table contains messages generated by the Auctions component.
Column Name | Column Type | Column Description |
---|---|---|
BASE | TIMESTAMP NULL |
Fixed time stamp used with the delay to determine when a message is sent by e-mail. |
CONTENT | LONG VARCHAR NULL |
A text field that contains the message content. |
DELAY | TIMESTAMP NULL |
The amount of time that must elapse before an email is sent to the recipient. The delay is the base plus the delay time (for example, 1 hour). |
MEMBER_ID | BIGINT NOT NULL |
Member ID. The member who is sending the message. For auctions, this is the owner of the auction. |
MESSAGE_ID | BIGINT NOT NULL |
Message ID. The primary key for the table. |
MSGPARAM1 | VARCHAR (254) NULL |
Contains the bid ID used for for the following messages: auction won, bid overridden, or order completed. |
MSGPARAM2 | VARCHAR (254) NULL |
Contains the auction ID used with the start auction message. |
MSGPARAM3 | VARCHAR (254) NULL |
Reserved for IBM internal use. |
MSGTYPE | INTEGER NULL |
Message type. Valid values: 1=start auction, 2=auction won, 3=auction lost, 4=bid overridden, 5=order completed |
POSTTIME | TIMESTAMP NULL |
Date and time the message was posted. |
SUBJECT | VARCHAR (254) NULL |
A text field that contains the subject of the message. |
TARGET_ID | BIGINT NULL |
Auction ID and bid ID. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000156 | MSGTYPE | Non-Unique Index |
I0000157 | DELAY | Non-Unique Index |
I0000158 | BASE | Non-Unique Index |
I0000159 | TARGET_ID | Non-Unique Index |
SQL030416035004160 | MESSAGE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_459 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_463 | MESSAGE_ID | MSGMEMREL | MESSAGE_ID | Cascade |