MERCHANT
This table stores the information of the value object container Credit for credit-related transactions in the payments subsystem.
Column Descriptions:
Name 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 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented. FIELD1 INTEGER For customizable use FIELD2 VARCHAR (250) For customizable use FIELD3 VARCHAR (250) For customizable use
Indexes:
Name Column Names Type <SYSTEM-GENERATED> MERCHANT_ID Primary Key I0001262 MEMBER_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_3466 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_3468 MERCHANT_ID STOREMERCH MERCHANT_ID Cascade F_3469 MERCHANT_ID MERCHCONF MERCHANT_ID Cascade