Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MERCHANT
This table stores the information of the value object container Credit for credit-related transactions in the WebSphere Commerce Payments.
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 SQL100520030355440 MERCHANT_ID Primary Key I0001262 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3466 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By 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 _vcc_freeselect_bottom_