Database Table: MSGSTORE

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

Column Name Column Type Column Description
EXPIRY TIMESTAMP
NULL
Expiry timestamp for stopping retrying to send the message (applicable to e-mail retry only).
MESSAGE LONG VARCHAR
NULL
Represents a segment of the stored message.
MESSAGEINDEX INTEGER
NOT NULL
Index number indicating which segment of the stored message this record represents.
MSGID BIGINT
NOT NULL
ID number uniquely identifying the message.
RETRIES INTEGER
NULL
Number of retries remaining for this message before send is abandoned.
STOREENT_ID INTEGER
NOT NULL
Store ID for the store from which this message originated.
TRANSPORT_ID INTEGER
NOT NULL
Transport ID for the transport from which this message is being sent.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035006500 MSGID, MESSAGEINDEX, TRANSPORT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1024 TRANSPORT_ID TRANSPORT TRANSPORT_ID Cascade
F_1025 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable