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