ml_subscription

Keeps track of the log offsets per subscription for Adaptive Server Anywhere remote databases.

Row	Description
user_id	INTEGER. Primary key. The user_id column references the user_id column of the ml_user table. This is the ID of a user who has subscribed to the publication.
subscription_id	VARCHAR(128). Primary key. The subscription_id is a number that is generated by Adaptive Server Anywhere on the remote.
publication_name	VARCHAR(128). Primary key. The publication_name stores the user-defined name for the publication.
progress	NUMERIC(20,0). The progress, also called the offset, refers to the point in the remote transaction log up to which all operations for the subscription have been uploaded. This column is used for version 8.0 and up databases. For version 7 databases, the progress is stored in the ml_user table.
last_download_time	TIMESTAMP. Indicates the last time a download was applied to the consolidated for a given user or subscription. The default is January 1, 1900, 00:00:00.
last_upload_time	TIMESTAMP. Indicates the last time an upload was applied to the consolidated for a given user or subscription. The default is January 1, 1900, 00:00:00.