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