bankhcon

Tables (3)

Account (계좌)

  • ID (id) — INT — Primary key — NOT NULL
  • userId (유저아이디) — INT — Foreign key → User.ID — NOT NULL
  • money (잔액) — INT

User (사용자)

  • ID (id) — INT — Primary key — NOT NULL
  • email (이메일) — VARCHAR2(255)
  • name (이름) — VARCHAR2(255)
  • password (비밀번호) — VARCHAR2(255)

tradeHistory (거래내역)

  • ID (거래내역id) — INT — Primary key — NOT NULL
  • accountId (계좌Id) — INT — Foreign key → Account.ID — NOT NULL
  • type (입출금) — VARCHAR2(10)
  • tradeMoney (거래금액) — INT
  • tradeDate (거래날짜) — DATETIME