Database Table: MESSAGE

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.
Indexes:
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
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_459 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_463 MESSAGE_ID MSGMEMREL MESSAGE_ID Cascade