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 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.