Appendix A: Distribution Database Schema

Connections table

The connections table stores information about ASE Replicator database connections.

Table A-4 lists the columns in the connections table.

**Table A-4: Connections table**
Column name	Datatype	Description
conn_id	numeric(18,0)	Connection ID.
conn_type	smallint	Type of connection (primary or replicate).
ds	rpl_sysname	Name of the database server.
db	rpl_sysname	Name of the database.
lastcommit_proxy	rpl_sysname	Name of lastcommit proxy table (replicate connections only).
maint_user	rpl_sysname	Maintenance User login name.
reset_extlogin	rpl_boolean	Indicates whether ASE Replicator created the Maintenance User as an external login.
log_locator	varchar(70)	If primary connection, log_locator identifies the restart position in the database log. If replicate connection, log_locator identifies the restart position in the stable queue.
status	smallint	Status of the connection.
status_desc	varchar(255)	Status description.

Each row in the connections table identifies a single database connection.

When you create a primary or replicate database connection, a row is added to the connections table to identify the new connection.

When you delete a primary or replicate database connection, the row identifying that connection is deleted from the connections table.