Database Table: MSGARCHIVE

This table stores sent messages (if ARCHIVEMSG = "1" is set for the message profile). The stored messages can be resent using the integrated GUI in the Administration Console.

Column Name Column Type Column Description
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.
MSGARCHIVE_ID BIGINT
NOT NULL
Archived message ID identifying a message.
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
SQL030416035005280 MSGARCHIVE_ID, MESSAGEINDEX, TRANSPORT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1014 TRANSPORT_ID TRANSPORT TRANSPORT_ID Cascade
F_1015 STOREENT_ID STOREENT STOREENT_ID Cascade

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