Appendix A: Distribution Database Schema

Replicate articles table

The rep_articles table stores information about all ASE Replicator replicate articles.

Table A-11 lists the columns in the rep_articles table.

**Table A-11: Replicate articles table**
Column name	Datatype	Description
rart_id	numeric(18,0)	Replicate article ID
part_id	numeric(18,0)	ID of primary article to which the replicate article subscribes
subid	numeric(18,0)	ID of subscription to which the replicate article belongs
rart_name	rpl_sysname	Name of replicate article
proc_num	smallint	Stored procedure group number
proxy_name	rpl_sysname	Name of the proxy table for the article
dist_proc	rpl_sysname	Name of the distribution procedure for the article
owner	rpl_sysname	Owner of the replicate object
valid_pt	varchar(70)	Locator value of the validation point for the article
where_clause	varchar(1837)	Optional where clause for the article

Each row in the rep_articles table identifies a single replicate article.

When you create a replicate article, a row is added to the rep_articles table for the new article.

When you delete a replicate article, the row that identifies that replicate article is deleted from the rep_articles table.