STGSITETAB

The stage configuration table for all site tables.

Column Descriptions:

NameTypeDescription
TABNBRINTEGER NOT NULLThe reference number of the table. The parent table must have a lower reference number than any child table.
TABNAMECHAR (30)The table name.
UPDATABLE_UK_COLVARCHAR (128)Column to use to support cyclical use of unique-key values during StagingProp. This column should be part of the supplementary unique-key (unique index) of the table recorded in TABNAME column.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TABNBRPrimary Key