WebSphere Commerce database table: MERCHCONFINFO

WebSphere Commerce database table: MERCHCONFINFO

This table stores the NVPs for properties of merchant information for a specific merchant configuration.
Column Descriptions
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
SQL060903235214650 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

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

Index Name	Indexed Column Names	Index Type
I0000973	MERCHCONF_ID+PROPERTY_NAME	Unique Index
SQL060903235214650	MERCHCONFINFO_ID	Primary Key