WebSphere Commerce database table: STOREMERCH

This table stores the mapping information indicates which merchant id is used for a specific store.

Column Descriptions

Column Name	Column Type	Description
STORE_ID	INTEGER NOT NULL	Store identifier
MERCHANT_ID	BIGINT NOT NULL	Merchant identifier
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	IBM internal use
FIELD1	INTEGER	For customizable use
FIELD2	VARCHAR(250)	For customizable use
FIELD3	VARCHAR(250)	For customizable use

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235255630	STORE_ID	Primary Key

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_3468	MERCHANT_ID	MERCHANT	MERCHANT_ID	Cascade
F_3467	STORE_ID	STORE	STORE_ID	Cascade