테이블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