welpsy

Tables (5)

tb_bank (뱅킹)

  • idx (유저ID) — pk,nn,ai — Foreign key → tb_user.idx — NOT NULL
  • accountNumber (계좌번호) — nn, uq
  • balance (잔액)

tb_bank_log (뱅킹 로그)

  • idx (인덱스) — pk,nn,ai — Primary key — NOT NULL
  • bank_type (거래종류) — nn
  • money (거래액) — nn
  • bank_id (유저ID) — nn, uq — Foreign key → tb_bank.idx — NOT NULL

tb_room (챌린지)

  • idx (인덱스) — pk,nn,ai — Primary key — NOT NULL
  • title (제목) — nn
  • description (설명글) — nn
  • goal_amount (목표금액) — nn
  • image_url (이미지 url) — nn
  • category (카테고리e) — nn

tb_room_list (방 가입 명단)

  • uuid (UUID) — nn,pk,ai — Primary key — NOT NULL
  • user_id (유저ID) — pk,nn,ai — Foreign key → tb_user.idx — NOT NULL
  • room_id (챌린지ID) — pk,nn,ai — Foreign key → tb_room.idx — NOT NULL

tb_user (유저)

  • idx (인덱스) — pk,nn,ai — Primary key — NOT NULL
  • email (이메일) — nn, uq
  • name (이름) — nn
  • phoneNumber (전화번호) — nn
  • password (비밀번호) — nn
  • userRole (유저권한) — nn