This table is used only for QAnywhere applications.
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 (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 |