BankAccount(get,post,put,delete)

Tables (3)

BankAccount_accounts (Untitled2)

  • Account ID (account_id) — INT(10) — Primary key — NOT NULL
  • User_id — INT(10) — Foreign key → BankAccount_users.User ID — NOT NULL
  • 계좌번호 (account_number) — VARCHAR(20)
  • 비밀번호 (password) — VARCHAR(100)
  • 계좌잔고 (balance) — DECIMAL(15.2)

BankAccount_transactions (Untitled3)

  • Transactions ID (transactions_id) — INT(10) — Primary key — NOT NULL
  • Account ID (account_id) — INT(10) — Foreign key → BankAccount_accounts.Account ID — NOT NULL
  • 입출금 (amount) — DECIMAL(15,2)
  • 입출금 기록 (Transactions_date) — VARCHAR(100)
  • 입금거래설명 (description) — TEXT
  • 거래시간 (datatime) — DATETIME

BankAccount_users (Untitled)

  • User ID (User_id) — INT(10) — Primary key — NOT NULL
  • 이름 (fullname) — VARCHAR(255)
  • 핸드폰 (phone) — VARCHAR(20)
  • 이메일 (emali) — VARCHAR(100)
  • 주소 (address) — VARCHAR(300)
  • 아이디 (id) — VARCHAR(300)
  • 비밀번호 (password) — VARCHAR(300)