Fintech

Tables (6)

Account (계좌)

  • accountNum — String — Primary key
  • userId — String — Foreign key → USER.userId — NOT NULL
  • accountName — String
  • accountType — String
  • balance — String
  • dtEmailVerified — String

Deposit (입금)

  • depositId — Long — Primary key — NOT NULL
  • accountNum (accountNum2) — String — Foreign key → Account.accountNum
  • userId — String — Foreign key → Account.userId — NOT NULL
  • dpAmount — Long

Transfer (송금)

  • senderAccountNum — String — Primary key
  • ReciveAccountNum (reciveAccountNum) — String — Primary key
  • userId — String — Foreign key → Account.userId — NOT NULL
  • trId — Foreign key → TransferRecord.trId — NOT NULL
  • tfAmount — Long
  • memo
  • transferDt — LocalDateTime

TransferRecord (송금기록)

  • trId — Primary key — NOT NULL
  • tId — String
  • TimeStamp — LocalDateTime
  • content — String

USER (고객 테이블)

  • userId — String — Primary key — NOT NULL
  • userPw — String
  • userName — String
  • userPhone (phone) — String
  • userEmail — String
  • ctDate — LocalDateTime
  • dtDate — LocalDateTime
  • mdDate — LocalDateTime
  • emailVerified — boolean
  • accountCnt — int
  • verificationDt — LocalDateTime
  • emilVerificationCode (emailVerificationCode) — String

Withdraw (출금)

  • withdrawId — Long — Primary key — NOT NULL
  • accountNum (accountNum2) — String — Foreign key → Account.accountNum
  • userId — String — Foreign key → Account.userId — NOT NULL
  • wdAmount — Long
  • monthCheckDt — LocalDate