MERCHANT

This table stores the information of the value object container Credit for credit-related transactions in the payments subsystem.

Column Descriptions:

NameTypeDescription
MERCHANT_IDBIGINT NOT NULLMerchant identifier
MEMBER_IDBIGINT NOT NULLThe owner of this merchant
NAMEVARCHAR (250) NOT NULLMerchant name
STATESMALLINT DEFAULT 1The state of this merchant, Flag indicating whether the merchant is active or not, where 0=false and 1=true.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
FIELD1INTEGERFor customizable use
FIELD2VARCHAR (250)For customizable use
FIELD3VARCHAR (250)For customizable use

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MERCHANT_IDPrimary Key
I0001262MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3466MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3468MERCHANT_IDSTOREMERCHMERCHANT_IDCascade
F_3469MERCHANT_IDMERCHCONFMERCHANT_IDCascade