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