테이블ERD

테이블 (3)

DEPOSIT_INFO

  • ACCOUNT_NO (계좌번호) — VARCHAR2(20)
  • ACCOUNT_ST_CD — VARCHAR2(2) — 계좌
  • ACCOUNT_TYPE_CD — VARCHAR2(2) — 계좌
  • CUSTOMER_NO — NUMBER — 계좌
  • OPEN_DT — DATE — 계좌
  • MATURITY_DT — DATE — 계좌
  • CURRENT_BAL — NUMBER(15, 2) — 현재
  • ACCOUNT_DESC — VARCHAR2(255) — 계좌
  • INTEREST_RATE — NUMBER(5, 2) — 계좌
  • FEE_EXEMPTION_FLAG — VARCHAR2(1) — 수수료

DEPOSIT_TRSC_HIS

  • ACCOUNT_NO1 (계좌번호1) — 기본 키 — NOT NULL
  • ACCOUNT_NO (계좌번호) — VARCHAR2(20) — NOT NULL
  • TRSC_SEQ_NO — NUMBER
  • TRSC_ST_CD — VARCHAR2(2)
  • TRSC_DT — DATE
  • TRSC_TM — VARCHAR2(8)
  • REAL_PROC_DT — DATE
  • REAL_PROC_TM — VARCHAR2(8)
  • CANCEL_DT — DATE
  • CANCEL_TM — VARCHAR2(8)
  • CANCEL_TRSC_SEQ_NO — NUMBER
  • TRANSFER_PROC_CD — VARCHAR2(2)
  • DEBIT_CREDIT_CD — VARCHAR2(2)
  • TRSC_TYPE_CD — VARCHAR2(2)
  • TRSC_CURRENCY_CD — VARCHAR2(3)
  • BF_TRSC_BAL — NUMBER(15, 2)
  • TRSC_AMT — NUMBER(15, 2)
  • AF_TRSC_BAL — NUMBER(15, 2)
  • FEE_AMT — NUMBER(15, 2)

NOTIFICATION_TEMPLATE

  • TEMPLATE_ID — VARCHAR2(20)
  • TEMPLATE_TYPE_CD — VARCHAR2(2)
  • TEMPLATE_BUSINESS_CD — VARCHAR2(2)
  • TEMPLATE_DESCRIPTION — VARCHAR2(255)
  • TEMPLATE_TITLE — VARCHAR2(4000)
  • TEMPLATE_MESSAGE_CONTENT — CLOB