Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
This table is used only for QAnywhere applications.
Do not alter this table.
|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 (canceled), 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 for 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.|
PRIMARY KEY( msgid, address )
FOREIGN KEY ( msgid ) REFERENCES ml_qa_repository( msgid )
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|