test
Tables (4)
ACCOUNTS (계좌)
- ACC_NO (계좌번호) — VARCHAR(20) — Primary key — NOT NULL
- CREATED_DATE (생성일자) — DATE
- BALANCE (잔액) — NUMBER(15,0)
ACCOUNTS_TXN (거래내역)
- TXN_ID (거래ID) — NUMBER — Primary key — NOT NULL
- ACC_NO (계좌번호) — VARCHAR2(20) — Foreign key → ACCOUNTS.ACC_NO — NOT NULL
- TXN_DATE (거래일자) — DATE
- TXN_AMOUNT (거래금액) — NUMBER(15,0)
- TXN_TYPE (입출금 구분) — CHAR(1)
- ACCESS_IP (거래IP) — VARCHAR2(45)
AUDIT_LOG (감사로그)
- LOG_ID (감사로그ID) — NUMBER — Primary key — NOT NULL
- TXN_ID (거래ID) — NUMBER — Foreign key → ACCOUNTS_TXN.TXN_ID — NOT NULL
- IS_LARGE_TXN (고액거래 여부) — CHAR(1)
- IS_ABNORMAL_IP (비정상IP 여부) — CHAR(1)
- REPEAT_TXN (거래 횟수) — NUMBER
- CREATED_DATE (로그 생성일자) — DATE
- AUDIT_REASON (탐지 사유) — VARCHAR2(500)
REPEAT_TXN_REPORT(VIEW) (반복거래리포트)
- ACC_NO (계좌번호) — VARCHAR(20) — Foreign key → ACCOUNTS.ACC_NO — NOT NULL
- DEPOSIT_COUNT (입금횟수) — DATE
- WITHDRAW_COUNT (출금횟수)
- DEPOSIT_TOTAL_AMOUNT (입금총금액)
- WITHDRAW_TOTAL_AMOUNT (출금총금액)
- CREATED_DATE (리포트 생성일자)