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