dup
Tables (5)
PG_COMMISSION_CODE
- CODE — VARCHAR2(10) — Primary key — NOT NULL
- PG_ID — VARCHAR2(10) — NOT NULL
- PAYMENT_METHOD — VARCHAR2(10) — NOT NULL
- DESCRIPTION — VARCHAR2(100) — NOT NULL
- COMMISSION_RATE — NUMBER(10, 2) — NOT NULL
- START_DATE — DATE — NOT NULL
- END_DATE — DATE — NOT NULL
SERVICE_COMMISSION_CODE
- CODE — VARCHAR2(10) — Primary key — NOT NULL
- SERVICE_NO — BIGINT — NOT NULL
- PAYMENT_METHOD — VARCHAR2(10) — NOT NULL
- DESCRIPTION — VARCHAR2(100) — NOT NULL
- COMMISSION_RATE — NUMBER(10, 2) — NOT NULL
- START_DATE — DATE — NOT NULL
- END_DATE — DATE — NOT NULL
TB_MERCHANT_SETTLE_INFO
- ID — BIGINT — NOT NULL
- MERCHANT_NO — BIGINT — NOT NULL
- SETTLE_PERIOD_CODE — VARCHAR2(10) — NOT NULL
- SETTLE_LIMIT — BIGINT — NOT NULL
- START_DATE — DATE — NOT NULL
- END_DATE — DATE — NOT NULL
TB_SETTLE_DATE
- ID — BIGINT — NOT NULL
- SETTLE_PERIOD_CODE — VARCHAR2(10) — NOT NULL
- SETTLE_DATE — INT — NOT NULL
- DESCRIPTION — VARCHAR2(100) — NOT NULL
TB_SETTLE_PERIOD_CODE
- CODE — VARCHAR2(10) — NOT NULL
- DESCRIPTION — VARCHAR2(100) — NOT NULL