Account

Tables (3)

Account (계좌)

  • id — Long — Primary key — NOT NULL
  • id (id2) — Long — Foreign key → User.id — NOT NULL
  • user (유저) — User
  • accountNumber (계좌번호) — String
  • accountStatus (계좌상태) — AccountStatus
  • balance (잔액) — Long
  • registeredAt (생성일) — LocalDateTime
  • unRegisteredAt (해지일) — LocalDateTime

Transaction (거래)

  • id — Long — Primary key — NOT NULL
  • id (id2) — Long — Foreign key → Account.id — NOT NULL
  • id (id22) — Long — Foreign key → Account.id — NOT NULL
  • account (계좌) — Account
  • transactionType (거래종류) — TransactionType
  • transactionResultType (거래결과종류) — TransactionResultType
  • amount (거래금액) — Long
  • balanceSnapshot (잔액) — Long
  • transactionId (거래아이디) — String
  • transactedAt (거래일) — LocalDateTime

User (유저)

  • id — Long — Primary key — NOT NULL
  • name (이름) — String