MERCHCONFINFO

This table stores the NVPs for properties of merchant information for a specific merchant configuration.

Column Descriptions:

Name	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	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	MERCHCONFINFO_ID	Primary Key
I0000973	MERCHCONF_ID+PROPERTY_NAME	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3470	MERCHCONF_ID	MERCHCONF	MERCHCONF_ID	Cascade