WebSphere Commerce database table: STGMRSTTAB

WebSphere Commerce database table: STGMRSTTAB

The stage configuration table for all tables containing both merchant and site information.
Column Descriptions
Column Name Column 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(25) The table name.
COLNAME CHAR(25) The name for the column used to identify if the row is site or merchant related.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235252700 TABNBR Primary Key
Related reference

Staging server data model

Column Name	Column 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(25)	The table name.
COLNAME	CHAR(25)	The name for the column used to identify if the row is site or merchant related.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.