Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce 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 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 SQL100520030357020 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
_vcc_freeselect_bottom_