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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035005280 | MSGARCHIVE_ID, MESSAGEINDEX, TRANSPORT_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|