money

Tables (8)

Account (계좌)

  • account_number (pk) — Long — Primary key — NOT NULL
  • user_id (유저ID) — Long — Primary key
  • bank_id (은행ID) — Long — Primary key
  • balance (금액) — double
  • transaction_count (송금횟수) — Long
  • name (계좌별명) — varchar
  • account_number_raw (계좌번호문자열) — varchar
  • created_at (생성일) — timestamp
  • updated_at (수정일) — timestamp

AuthToken (토큰)

  • ID (pk) — Long — Primary key — NOT NULL
  • user_id (uk) — Long — Primary key
  • token (토큰) — varchar
  • expire_date (만료시간) — timestamp

Bank (은행)

  • ID (pk) — Long — Primary key — NOT NULL
  • name (은행명) — varchar
  • created_at (생성일) — timestamp

EmailAuthLog (이메일 인증 로그)

  • ID (pk) — Long — Primary key — NOT NULL
  • user_id (유저ID) — Long
  • user_email (유저이메일) — Long
  • status (인증 성공) — varchar
  • created_at (인증 시간) — timestamp

LoginLog (로그인 로그)

  • ID (pk) — Long — Primary key — NOT NULL
  • user_id (유저ID) — Long
  • user_email (유저이메일) — Long
  • status (로그인 성공) — varchar
  • created_at (인증 시간) — timestamp

Transaction (계좌이체)

  • ID (pk) — Long — Primary key — NOT NULL
  • from_account_id (출금계좌ID) — Long
  • to_account_id (입금계좌ID) — Long
  • from_account_name (출금계좌주명) — varchar
  • to_account_name (입금계좌주명) — varchar
  • amount (이체금액) — double
  • memo (메모) — varchar
  • created_at (거래일시) — timestamp

TransactionLog (계좌이체로그)

  • ID (pk) — Long — Primary key — NOT NULL
  • transaction_id (이체ID) — Long
  • from_account_number (출금계좌) — Long
  • from_account_id (출금계좌ID) — Long
  • to_account_number (입금계좌) — Long
  • to_account_id (입금계좌ID) — Long — NOT NULL
  • from_account_name (출금계좌주명) — varchar
  • to_account_name (입금계좌주명) — varchar
  • amount (금액) — double
  • status (입/출금상태) — varchar
  • created_at (거래일시) — timestamp

User (사용자)

  • ID (pk) — Long — Primary key — NOT NULL
  • email (uk) — varchar — Primary key
  • password (비밀번호) — varchar
  • name (이름) — varchar
  • created_at (생성일) — timestamp
  • updated_at (수정일) — timestamp
  • transaction_password (송금비밀번호) — varchar