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|