Each row in the SYSSUBSCRIPTION system view describes a subscription from one user ID (which must have REMOTE permissions) to one publication. The underlying system table for this view is ISYSSUBSCRIPTION.
|Column name||Column type||Column constraint|
|publication_id||UNSIGNED INT||NOT NULL|
|user_id||UNSIGNED INT||NOT NULL|
|created||UNSIGNED BIGINT||NOT NULL|
publication_id The identifier for the publication to which the user ID is subscribed.
user_id The ID of the user who is subscribed to the publication.
subscribe_by The value of the SUBSCRIBE BY expression, if any, for the 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.
PRIMARY KEY (publication_id, user_id, subscribe_by)
FOREIGN KEY (publication_id) references SYS.ISYSPUBLICATION (publication_id)
FOREIGN KEY (user_id) references SYS.ISYSUSER (user_id)