This table contains messages generated by the Auctions component.
Column Description(s):
Column Name | Column Type | Description |
MESSAGE_ID |
BIGINT NOT NULL |
Message ID. The primary key for the table. |
MEMBER_ID |
BIGINT NOT NULL |
Member ID. The member who is sending the message. For auctions, this is the owner of the auction. |
MSGTYPE |
INTEGER |
Message type. Valid values are as follows:
- 1=start auction
- 2=auction won
- 3=auction lost
- 4=bid overridden
- 5=order completed
|
SUBJECT |
VARCHAR(254) |
A text field that contains the subject of the message. |
POSTTIME |
TIMESTAMP |
Date and time the message was posted. |
CONTENT |
CLOB |
A text field that contains the message content. |
MSGPARAM1 |
VARCHAR(254) |
Contains the bid ID used for for the following messages: auction won, bid overridden, or order completed. |
MSGPARAM2 |
VARCHAR(254) |
Contains the auction ID used with the start auction message. |
MSGPARAM3 |
VARCHAR(254) |
Reserved for IBM internal use. |
DELAY |
TIMESTAMP |
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). |
BASE |
TIMESTAMP |
Fixed time stamp used with the delay to determine when a message is sent by e-mail. |
TARGET_ID |
BIGINT |
Auction ID and bid ID. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031240090 |
MESSAGE_ID |
Primary Key |
I0000156 |
MSGTYPE |
Non-Unique Index |
I0000157 |
DELAY |
Non-Unique Index |
I0000158 |
BASE |
Non-Unique Index |
I0000159 |
TARGET_ID |
Non-Unique Index |
I0000619 |
MEMBER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_459 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_463 |
MESSAGE_ID |
MSGMEMREL |
MESSAGE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.