AccountERD

테이블 (3)

거래 (transaction)

  • id (Key) — big int — 기본 키 — NOT NULL
  • accountId (Key2) — big int — 외래 키 → 계좌.id — NOT NULL
  • transactionType (Field) — varchar(20)
  • transactionResultType (Field2) — varchar(2)
  • amount (Field3) — big int
  • balanceSnapshot (Field4) — big int
  • transactionId (Field5) — varchar(50)
  • transactedAt (Field6) — datetime
  • createdAt (Field7) — datetime
  • updatedAt (Field8) — datetime

계좌 (account)

  • id (Key) — big int — 기본 키 — NOT NULL
  • accountUserId (Key2) — big int — 외래 키 → 유저.id — NOT NULL
  • accountNumber (Field) — varchar(10)
  • accountStatus (Field2) — varchar(20)
  • balance (Field3) — big int
  • registeredAt (Field4) — datetime
  • unRegisteredAt (Field5) — datetime
  • createdAt (Field6) — datetime
  • updatedAt (Field7) — datetime

유저 (account_user)

  • id (Key) — bit int — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime