WebSphere Commerce database table: MERCHANT

This table stores the name and the state of a merchant.

Column Descriptions

Column Name	Column Type	Description
MERCHANT_ID	BIGINT NOT NULL	Merchant identifier
MEMBER_ID	BIGINT NOT NULL	The owner of this merchant
NAME	VARCHAR(250) NOT NULL	Merchant name
STATE	SMALLINT DEFAULT 1	The state of this merchant, Flag indicating whether the merchant is active or not, where 0=false and 1=true.
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
SQL060903235214370	MERCHANT_ID	Primary Key

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_3466	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_3469	MERCHANT_ID	MERCHCONF	MERCHANT_ID	Cascade
F_3468	MERCHANT_ID	STOREMERCH	MERCHANT_ID	Cascade