ml_qa_delivery

This table is used only for QAnywhere applications.

Caution

Do not alter this table.

Column Description
msgid VARCHAR(128). Globally unique message identifier.
seqno BIGINT. Used to give an ordering to the messages, which is necessary for true queuing.
address VARCHAR(255). Address of the target recipient.
clientaddress VARCHAR(128). Client part of the address.
client VARCHAR(128). Client targeted by current client state.
originator VARCHAR(128). The name of the originating client.
priority INTEGER. A number from 0 to 9. Messages with a higher priority number are delivered before messages with a lower priority. The default is 4.
expires TIMESTAMP. The expiry time after which the message might not be delivered.
kind INTEGER. Indicates whether the message is binary (1) or text (2).
contentsize BIGINT. The size of the message. For binary messages, this is the number of bytes. For text messages, this is the number of characters.
status INTEGER. The status of the message. Can be 1 (pending), 10 (receiving), 30 (expired), 40 (cancelled), 50 (unreceivable), or 60 (received).
statustime TIMESTAMP. The time this status was achieved. The time is local to the client achieving the state.
syncstatus INTEGER. The state of the synchronization between the client and server with respect to this message. Can be 0 (not in sync), 1 (in sync), 2 (message should not be synchronized), or 3 (synchronizing).
receiverid VARCHAR(128). An identifier set by the receiver that identifies the receiver of the message, if any.
Constraints

PRIMARY KEY( msgid, address )

FOREIGN KEY ( msgid ) REFERENCES ml_qa_repository( msgid )