Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MERCHCONFINFO
This table stores the NVPs for properties of merchant information for a specific merchant configuration.
Column Name Column Type Description MERCHCONFINFO_ID BIGINT NOT NULL Merchant configuration information identifier MERCHCONF_ID BIGINT NOT NULL Merchant configuration id for the current NVP PROPERTY_NAME VARCHAR(64) NOT NULL Property name PROPERTY_VALUE VARCHAR(4000) NOT NULL Property value ENCRYPTED SMALLINT NOT NULL DEFAULT 1 Indicates if the value is encrypted. 0:The value is not encrypted. 1:The value is encrypted. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 IBM internal use
Indexes Index Name Indexed Column Names Index Type I0000973 MERCHCONF_ID+PROPERTY_NAME Unique Index SQL100520030355730 MERCHCONFINFO_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3470 MERCHCONF_ID MERCHCONF MERCHCONF_ID Cascade _vcc_freeselect_bottom_