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.