WebSphere Commerce database table: MSGSTORE

This table holds the messages stored as a result of using a transacted send. Temporary storage space only.

Column Descriptions
Column Name Column Type Description
MSGID BIGINT NOT NULL ID number uniquely identifying the message.
MESSAGEINDEX INTEGER NOT NULL Index number indicating which segment of the stored message this record represents.
MESSAGE BLOB Represents a segment of the stored message.
RETRIES INTEGER Number of retries remaining for this message before send is abandoned.
EXPIRY TIMESTAMP Expiry timestamp for stopping retrying to send the message (applicable to e-mail retry only).
TRANSPORT_ID INTEGER NOT NULL Transport ID for the transport from which this message is being sent.
STOREENT_ID INTEGER NOT NULL Store ID for the store from which this message originated.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235215540 MSGID+MESSAGEINDEX+TRANSPORT_ID Primary Key
I0000624 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1025 STOREENT_ID STOREENT STOREENT_ID Cascade
F_1024 TRANSPORT_ID TRANSPORT TRANSPORT_ID Cascade
Related reference