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