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