|
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 a total ordering to the messages, this is necessary for true queuing. |
| address | VARCHAR(255). Address of the target recipient. |
| target | VARCHAR(128).Client targeted by the current state. |
| originator | VARCHAR(255). The name of the originating MobiLink user. |
| priority | INTEGER. A number from 0 to 9. Messages with a higher number are delivered before messages with a lower number. The default is 4. |
| expires | TIMESTAMP. 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 (receivable), or 60 (received). |
| statustime | TIMESTAMP. The time this status was achieved. The time is local to the client achieving the state. |
| verbiage | VARCHAR (32767). Localized description of the status (if any). |
| syncstatus | INTEGER. Indicates the state of the synchronization between the client and server with respect to this message. Can be 0 (not in sync), 1 (in sync), or 2 (message should not be synchronized). |
| receiverid | VARCHAR(128). An identifier set by the receiver that identifies the receiver of the message, if any. |
The owner of this table is ml_qa_user_group.