BankApp

Tables (3)

Account (계좌)

  • 계좌번호 (account_no) — varchar2(50) — Primary key — NOT NULL
  • 잔액 (balance) — number
  • 계좌생성일 (create_at) — date
  • 아이디 (user_id) — varchar2(50) — Foreign key → Users.아이디 — NOT NULL

Transactions (거래내역)

  • 거래id (tx_id) — number — Primary key — NOT NULL
  • 거래종류 (tx_type) — varchar2(20) — NOT NULL
  • 거래금액 (amount) — number — NOT NULL
  • 이체대상계좌 (target_account) — varchar2(50)
  • 거래일시 (tx_date) — sysdate — NOT NULL
  • 계좌번호 (account_no) — varchar2(50) — Foreign key → Account.계좌번호 — NOT NULL

Users (회원)

  • 아이디 (user_id) — varchar2(50) — Primary key — NOT NULL
  • 비밀번호 (password) — varchar2(100) — NOT NULL
  • 회원이름 (user_name) — varchar2(50) — NOT NULL
  • 권한 (role) — varchar2(10)
  • 가입일자 (create_at) — sysdate