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 (리포트 생성일자)