piggyBank

Tables (5)

account

  • id — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.id — NOT NULL
  • name (bank_name) — varchar(50)
  • 계좌번호 (account_number) — varchar(100)
  • 예금주 (account_holder) — varchar(50)
  • 잔액 (balance) — BigDecimal

challenge (chanllenge)

  • id — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.id — NOT NULL
  • challenge_name — varchar(100)
  • 목표금액 (target_amount) — BigDecimal
  • 현재저축금액 (saved_amount) — BigDecimal
  • 시작날짜 (start_date) — LocalDate
  • 종료날짜 (end_date) — LocalDate
  • 저축주기 (saving_cycle) — int
  • challenge_description — varchar(500)
  • Field (challenge_status) — varchar(50)

transaction

  • id — long — Primary key — NOT NULL
  • virtual_account_id — long — Foreign key → virtual_account.challenge_id — NOT NULL
  • 거래일자 (transaction_date) — LocalDate
  • 금액 (amount) — BigDecimal
  • 거래종류 (transaction_type) — varchar(50)
  • 거래설명 (transaction_description) — varchar(100)

user

  • id — long — Primary key — NOT NULL
  • username — varchar(50)
  • password — varchar(50)
  • email — varchar(50)

virtual_account

  • id — long — Primary key — NOT NULL
  • challenge_id — long — Foreign key → challenge.id — NOT NULL
  • 계좌번호 (account_number) — varchar(100)
  • 잔액 (balance) — BigDecimal