Home > Technical > Table Definitions > LOGTABLE

LOGTABLE

This table is used as part of the Replication system. It records the details of tables that have changed so that they can be replicated.

Column

Type

Description

CTRCODE

INT(4)

A unique number assigned by the system.

STRTABLENAME

VARCHAR(30)

The name of the table that was changed.

STRACTION

VARCHAR(1)

The type of action that was performed against the table. (A)dd, (U)pdate or (D)elete.

STRKEY

VARCHAR(200)

A comma-delimited list of fields that make up the primary key. Each field is surrounded by double quotes (" ").

YSNOPTIMIZED

VARCHAR(1)

During the course of a day, the same record may be updated several times, producing several LOGTABLE records. The replication process will attempt to optimise these records so as to minimise the size of the final replication file. This flag will be 'F' until the record is optimised when it will be set to 'T'.

STRLOCATION

VARCHAR(200)

If a table is only set up to replicate to certain locations, this will be a comma-delimited list of those locations.

STRLOCATIONEXCLUDE

VARCHAR(200)

If a table is set up to NOT replicate to certain locations, this will be a comma-delimited list of those locations.

 

Primary Key: CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)