Appendix A: Distribution Database Schema

Replicate article fields table

The rart_fields table stores information about all subscribed fields for all replicate articles.

Table A-12 lists the columns in the rart_fields table.

**Table A-12: Replicate article fields table**
Column name	Datatype	Description
rart_id	numeric(18,0)	Replicate article ID
rart_colid	smallint	Column ID of replicate article field
rart_colname	rpl_sysname	Column name of replicate article field
is_identity	rpl_boolean	Indicates whether the column is an identity column
is_lob	rpl_boolean	Indicates whether the column is a large object datatype
is_null	rpl_boolean	Indicates whether the column can have a null value
dtype	int	Column datatype ID
dtype_name	rpl_sysname	Column datatype name
prec	int	Length of string or binary field, or precision of a numeric field, if applicable
scale	smallint	Scale of numeric field, if applicable
proxy_colid	smallint	Column ID of proxy table column
proxy_colname	rpl_sysname	Column name of proxy table column
part_id	numeric(18,0)	ID of primary article to which the replicate article subscribes
part_colid	int	Column ID of primary article field
part_colname	rpl_sysname	Column name of primary article field

Each row in the rart_fields table identifies a single subscribed field in a replicate article.

When you create a replicate article, a row is added to the rart_fields table for each subscribed field in the new article.

When you delete a replicate article, a row is deleted from the rart_fields table for each subscribed field in that article.