SYSSUBSCRIPTION system table

CREATE TABLE SYS.SYSSUBSCRIPTION (
	publication_id	 UNSIGNED INT NOT NULL,
	user_id	 UNSIGNED INT NOT NULL,
	subscribe_by	 CHAR(128) NOT NULL,
	created	 NUMERIC(20,0) NOT NULL,
	started	 NUMERIC(20,0),
	PRIMARY KEY (publication_id, user_id, subscribe_by),
	FOREIGN KEY REFERENCES SYS.SYSPUBLICATION,
	FOREIGN KEY REFERENCES SYS.SYSREMOTEUSER
);

Each row describes a subscription from one user ID (which must have REMOTE permissions) to one publication.

publication_id The identifier for the publication to which the user ID is subscribed.

user_id The user ID that is subscribed to the publication.

subscribe_by For publications with a SUBSCRIBE BY expression, this column holds the matching value for this subscription.

created The offset in the transaction log at which the subscription was created.

started The offset in the transaction log at which the subscription was started.