account
Tables (3)
Account (계좌)
- account_id (계좌 id) — long — Primary key — NOT NULL
- user_id (유저 id) — long — Foreign key → User.user_id — NOT NULL
- account_number (계좌번호) — string
- account_status (계좌상태) — AccountStatus
- balance (잔액) — long
- register_at (생성날짜) — LocalDateTime
- Unregister_at (해제날짜) — LocaDateTime
Transaction (거래내용)
- transaction_id (거래 id) — long — Primary key — NOT NULL
- account_id (계좌 id) — long — Foreign key → Account.account_id — NOT NULL
- transaction_type (거래 종류) — TransactionType
- transaction_result_type (거래 결과 내용) — TransactionResultType
- amount (거래 금액) — long
- balance_snapshot (Field) — long
- transaction_number (거래 번호) — string
- transacted_at (거래 시간) — LocalDateTime
User (유저)
- user_id (유저 id) — long — Primary key — NOT NULL
- name (유저 이름) — string