Sybase SQL Remote DC38133-01-0902-01 User Manual
SQL Remote system tables
This section describes the system tables used by SQL Remote to define and
manage SQL Remote information. In the following diagram, arrows indicate
foreign key relations between tables: the arrow leads from the foreign table
to the primary table.
manage SQL Remote information. In the following diagram, arrows indicate
foreign key relations between tables: the arrow leads from the foreign table
to the primary table.
SYSREMOTETYPE
type_id
type_name
publisher_address
remarks
type_name
publisher_address
remarks
SYSSUBSCRIPTION
publication_id
user_id
subscribe_by
created
started
user_id
subscribe_by
created
started
SYSARTICLE
publication_id
table_id
where_expr
subscribe_by_expr
query
table_id
where_expr
subscribe_by_expr
query
SYSPUBLICATION
publication_id
publication_name
remarks
publication_name
remarks
SYSARTICLECOL
publication_id
table_id
column_id
table_id
column_id
SYSREMOTEUSER
user_id
consolidate
type_id
address
frequency
send_time
log_send
time_sent
log_sent
confirm_sent
send_count
resend_count
time_received
log_received
confirm_received
receive_count
rereceive_count
consolidate
type_id
address
frequency
send_time
log_send
time_sent
log_sent
confirm_sent
send_count
resend_count
time_received
log_received
confirm_received
receive_count
rereceive_count
These tables are described in more detail in the following sections.
SYSARTICLE table
Function
Each row describes an article in a SQL Remote publication.
326