ASA SQL Reference
System Tables
| 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.