Appendix A: Distribution Database Schema

Primary article fields table

The part_fields table stores information about all published fields for all primary articles.

Table A-8 lists the columns in the part_fields table.

**Table A-8: Primary article fields table**
Column name	Datatype	Description
part_id	numeric(18,0)	Primary article ID
part_colid	int	Column ID of primary article field
part_colname	rpl_sysname	Column name of primary 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
prec	int	Length of string or binary field, or precision of a numeric field, if applicable
scale	smallint	Scale of numeric field, if applicable

Each row in the part_fields table identifies a single published field in a primary article.

When you create a primary article, a row is added to the part_fields table for each published field in the new article.

When you delete a primary article, a row is deleted from the part_fields table for each published field in that article.