welpsy

Tables (5)

tb_bank (뱅킹)

  • idx (인덱스) — nn,pk,ai — Primary key — NOT NULL
  • email (이메일) — nn,pk — Foreign key → tb_user.email — NOT NULL
  • accountNumber (계좌번호) — nn,uq
  • balance (잔액) — nn

tb_challenge (챌린지)

  • roomId (챌린지ID) — nn,pk,ai — Primary key — NOT NULL
  • title (제목) — nn
  • description (설명) — nn
  • goalMoney (목표금액) — nn
  • memberLimit (제한 멤버 수)
  • currenMember (현재 멤버 수)
  • imageUrl (제품 이미지) — nn
  • category (카테고리) — nn

tb_log (Untitled)

  • idx (인덱스) — nn,pk,ai — Primary key — NOT NULL
  • accountId (계좌ID) — nn,pk,ai — Foreign key → tb_bank.idx — NOT NULL
  • logType (거래종류) — nn

tb_member (멤버)

  • idx (인덱스) — nn,pk,ai — Primary key — NOT NULL
  • email (이메일) — nn,pk — Foreign key → tb_user.email — NOT NULL
  • roomId (챌린지ID) — nn,pk,ai — Foreign key → tb_challenge.roomId — NOT NULL

tb_user (유저)

  • email (이메일) — nn,pk — Primary key — NOT NULL
  • name (이름) — nn
  • phoneNumber (전화번호) — nn,uq
  • password (비밀번호) — nn
  • imageUrl (프로필 사진)
  • userRole (유저 권한) — nn