Appendix A: Distribution Database Schema

Primary articles table

The pri_articles table stores information about all ASE Replicator primary articles.

Table A-7 lists the columns in the pri_articles table.

**Table A-7: Primary articles table**
Column name	Datatype	Description
part_id	numeric(18,0)	Primary article ID
part_name	rpl_sysname	Name of primary article
conn_id	numeric(18,0)	Connection ID
art_type	smallint	Type of primary article (table or procedure)
shadow	rpl_sysname	Name of primary article shadow table
rarts_count	int	Number of replicate articles subscribing to this primary article
owner	rpl_sysname	Owner of the primary object
proc_num	smallint	Stored procedure group number

Each row in the pri_articles table identifies a single primary article.

When you create a primary article, a row is added to the pri_articles table for the new article.

When you create or delete a replicate article, the row that identifies the primary article subscribed to by that replicate article is updated in the pri_articles table to change the value of the rarts_count column.

When you delete a primary article, the row that identifies that primary article is deleted from the pri_articles table.

View this book as PDF