Appendix A: Distribution Database Schema

Publications table

The publications table stores information for all ASE Replicator publications.

Table A-6 lists the columns in the publications table.

**Table A-6: Publications table**
Column name	Datatype	Description
pubid	numeric(18,0)	Publication ID
name	varchar(128)	Name of publication
conn_id	numeric(18,0)	ID of the primary connection this publication belongs to

Each row in the publications table identifies a single publication.

When you create a publication, a row is added to the publications table for the new publication.

When you delete a publication, the row that identifies that publication is deleted from the publications table.