Appendix A: Distribution Database Schema

Subscriptions table

The subscriptions table stores information for all ASE Replicator subscriptions.

Table A-10 lists the columns in the subscriptions table.

**Table A-10: Subscriptions table**
Column name	Datatype	Description
subid	numeric(18,0)	Subscription ID
name	varchar(128)	Name of subscription
pubid	numeric(18,0)	ID of the publication to which this subscription subscribes
conn_id	numeric(18,0)	ID of the replicate connection this subscription belongs to
status	smallint	Status of the subscription
status_desc	varchar(255)	Status description

Each row in the subscriptions table identifies a single subscription.

When you create a subscription, a row is added to the subscriptions table for the new subscription.

When you delete a subscription, the row that identifies that subscription is deleted from the subscriptions table.