ml_qa_repository

ml_qa_repository_staging

This table is used only for QAnywhere applications. It contains messages that are to be sent to a QAnywhere client using SQL Anywhere version 9.0.1.

Do not alter this table.

Column	Description
seqno	BIGINT. Used to give a total ordering to the messages, this is necessary for true queuing.
msgid	VARCHAR(255). Globally unique message identifier.
destination	VARCHAR(128). The address of the message.
originator	VARCHAR(128). The name of the originating MobiLink user.
status	VARCHAR(128). The status of the message. Can be pending, receiving, received, unreceivable, expired, or cancelled. The default is pending.
statustime	TIMESTAMP. The last time the status was changed.
expires	TIMESTAMP. Expiry time after which the message are not delivered.
priority	INTEGER. A number from 0 to 9. Messages with a higher number are always delivered before messages with a lower number. The default is 4.
props	LONG BINARY. An encoding of the message properties.
kind	INTEGER. Indicates whether the message is binary (1) or text (2).
content	LONG BINARY. The content of the message. Text messages are encoded as UTF-8.
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.
mluser	VARCHAR(128). The MobiLink user name that uniquely identifies a remote database.

PRIMARY KEY( msgid )

Discuss this page in DocCommentXchange.
Send feedback about this page using email.