Chapter 15 System Tables
1037
SYSSUBSCRIPTION system table
Column name Column type
Column
constraint
Table constraints
publication_id UNSIGNED INT NOT NULL Primary key, foreign
key references
SYSPUBLICATION
user_id UNSIGNED INT NOT NULL Primary key, foreign
key references
SYSREMOTEUSER
subscribe_by CHAR(128) NOT NULL Primary key
created NUMERIC(20,0) NOT NULL
started NUMERIC(20,0)
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 number that 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.
To Next Page
Loading...