Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STOREMERCH
This table stores the mapping information indicates which merchant id is used for a specific store.
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 SQL100520030434680 STORE_ID Primary Key I0001289 MERCHANT_ID Non-Unique Index
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 _vcc_freeselect_bottom_