Database Table: STAGLOG

The staging server uses this table to track changes in the staging database.

Column Name Column Type Column Description
STGKEY1NAME CHARACTER (32)
NULL
Column name for the unique index.
STGKEY2NAME CHARACTER (32)
NULL
Column name for the unique index.
STGKEY3NAME CHARACTER (32)
NULL
Column name for the unique index.
STGKEY4NAME CHARACTER (32)
NULL
Column name for the unique index.
STGKEY5NAME CHARACTER (32)
NULL
Column name for the unique index.
STGLDCOLS VARCHAR (4000)
NULL
Reserved for IBM internal use.
STGLDPTH VARCHAR (254)
NULL
Reserved for IBM internal use.
STGMENBR INTEGER
NULL
Indicates whether the table is a:
0 = site table or 1 = merchant table.
STGMENBRNAME CHARACTER (32)
NULL
Reserved for IBM internal use.
STGNKEY1 BIGINT
NULL
New column value for the unique index.
STGNKEY2 BIGINT
NULL
New column value for the unique index.
STGNKEY3 VARCHAR (254)
NULL
New column value for the unique index.
STGNKEY4 BIGINT
NULL
New column value for the unique index.
STGNKEY5 VARCHAR (254)
NULL
New column value for the unique index.
STGOKEY1 BIGINT
NULL
Old column value for the unique index.
STGOKEY2 BIGINT
NULL
Old column value for the unique index.
STGOKEY3 VARCHAR (254)
NULL
Old column value for the unique index.
STGOKEY4 BIGINT
NULL
Old column value for the unique index.
STGOKEY5 VARCHAR (254)
NULL
Old column value for the unique index.
STGOP CHARACTER (1)
NOT NULL
The change operator: I = insert, U = update, D = delete.
STGPKEY BIGINT
NULL
The value of the primary key.
STGPKEYNAME CHARACTER (32)
NULL
The name of the primary key.
STGPROCESSED INTEGER
NULL, DEFAULT 0
0 = not processed, 1 = processed.
STGRESERVED1 INTEGER
NULL, DEFAULT 0
Reserved for IBM internal use.
STGRFNBR BIGINT
NOT NULL
The reference number for the staging row.
STGSTMP TIMESTAMP
NOT NULL
The time stamp.
STGTABLE CHARACTER (10)
NOT NULL
The name of the table with staged changes.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035107590 STGRFNBR Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable