User's 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.
SYSREMOTETYPE
type_id
type_name
publisher_address
remarks
SYSSUBSCRIPTION
publication_id
user_id
subscribe_by
created
started
SYSARTICLE
publication_id
table_id
where_expr
subscribe_by_expr
query
SYSPUBLICATION
publication_id
publication_name
remarks
SYSARTICLECOL
publication_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
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