WebSphere Commerce database table: STGSITETAB

STGSITETAB

The stage configuration table for all site tables.

Column Descriptions:

Name Type Description
TABNBR INTEGER NOT NULL The reference number of the table. The parent table must have a lower reference number than any child table.
TABNAME CHAR (30) The table name.
UPDATABLE_UK_COL VARCHAR (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.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> TABNBR Primary Key

Related reference
Staging environment data model

Name	Type	Description
TABNBR	INTEGER NOT NULL	The reference number of the table. The parent table must have a lower reference number than any child table.
TABNAME	CHAR (30)	The table name.
UPDATABLE_UK_COL	VARCHAR (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.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.