A. Data Dictionary Tables : Shadow Table
 
Share this page                  
Shadow Table
A shadow table has all the primary key columns of the base replicated table plus other Ingres Replicator columns. This table contains information that is needed for the replication—the timestamp indicating when the row was manipulated and a priority number indicating the processing priority of the row in the event of collision:
Column Name
Data Type
Description
column1
integer not null
Primary key of a replicated table.
sourcedb
smallint not null
Identifies the database where the transaction originated.
transaction_id
integer not null
Identifier given by the DBMS Server to the original transaction.
sequence_no
integer not null
The sequence of the operation (insert, update, delete) within the original transaction.
trans_time
date with null
The date and time when the transaction that manipulated the row was committed in the originating database.
distribution_time
date with null
The time of final distribution to a local database.
in_archive
integer1 not null with default
Indicates whether this row is in the archive table.
cdds_no
smallint not null with default
Identifies the CDDS.
trans_type
smallint not null
Indicates if this operation is an:
1 = insert
2 = update
3 = delete
dd_priority
smallint not null with default
The user-assigned priority to resolve collisions. This can be 0 or have been derived from a lookup table.
new_key
smallint not null with default
This field is set to one for an update or delete if a key had to be created for the original record.
old_sourcedb
smallint not null with default
Identifies the database that originated the transaction that manipulated the row before this transaction.
old_transaction_id
integer not null with default
Identifier given by the DBMS Server to the transaction that manipulated the row before this transaction.
old_sequence_no
integer not null with default
The sequence of the operation (insert, update, delete) within the transaction that manipulated the row before this transaction.