sysarticle system table

Each row in the sysarticle system table describes a table that belongs to a publication.

Column name Column type Description
publication _id UNSIGNED INT An identifier for the publication that this article belongs to.
table_id UNSIGNED INT The identifier of the table that belongs to the publication.
where_expr TINY INT An optional predicate to filter rows.
Constraints

PRIMARY KEY (publication_id, table_id)

FOREIGN KEY (publication_id) REFERENCES syspublication (publication_id)

FOREIGN KEY (table_id) REFERENCES systable (object_id)

See also