java_service

Tables (3)

ACCOUNT (계좌)

  • 계좌번호 (account_num) — Varchar2(20) — Primary key — NOT NULL
  • 비밀번호 (account_password) — Varchar2(4) — NOT NULL
  • 임시여부 (is_temporary) — CHAR(1) — NOT NULL
  • 잔고 (balance) — Integer — NOT NULL
  • 생성날짜 (create_date) — Date — NOT NULL
  • 유저키 (user_key) — Integer — Foreign key → Bank_user.유저키 — NOT NULL

Bank_user (사용자)

  • 유저키 (user_key) — Integer — Primary key — NOT NULL
  • 아이디 (user_id) — Varchar2(20) — NOT NULL
  • 비밀번호 (user_password) — Varchar2(20) — NOT NULL
  • 타입 (type) — Varchar2(10) — NOT NULL
  • 이름 (name) — Varchar2(20) — NOT NULL
  • 생년월일 (birth_day) — Date — NOT NULL

TRANSACTION (거래)

  • 거래키 (transaction_key) — Integer — Primary key — NOT NULL
  • 거래타입 (transaction_type) — Short — NOT NULL
  • 거래금액 (transaction_amount) — Integer — NOT NULL
  • 거래후잔액 (transaction_balance) — Integer — NOT NULL
  • 거래시간 (transaction_datetime) — Datetime — NOT NULL
  • 계좌번호 (account_num) — Varchar2(20) — Foreign key → ACCOUNT.계좌번호 — NOT NULL
  • 보낸사람 (transaction_send_name) — Varchar2(20)
  • 받은사람 (transaction_take_name) — Varchar2(20)
  • 거래대상계좌번호 (account_counterpart_num) — Varchar2(20) — Foreign key → ACCOUNT.계좌번호