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.