bank

Tables (3)

Account (계좌 테이블)

  • Account Number — Num(10) — Primary key — NOT NULL
  • User_id — Varchar(20) — Foreign key → Users.User_id — NOT NULL
  • Account Password — int(4)
  • Current Balance — int(20)

Transaction (거래 내역 테이블)

  • Transaction_id — Num(20) — Primary key — NOT NULL
  • Account Number — Num(10) — Foreign key → Account.Account Number — NOT NULL
  • User_id — Varchar(20) — Foreign key → Account.User_id — NOT NULL
  • Type — Varchar(10)
  • Amount — Int(30)
  • Target Account — Varchar(20)
  • Created_at — date

Users (회원 테이블)

  • User_id — Varchar(20) — Primary key — NOT NULL
  • Password — Int(6)