220627_1
Tables (5)
fee (Untitled4)
- Fee_id (id) — NOT NULL — Primary key — NOT NULL
- fine (벌금) — NOT NULL
- prize (상금) — NOT NULL
- Plan_id (id2) — NOT NULL — Foreign key → plan.Plan_id — NOT NULL
plan (Untitled3)
- Plan_id (id) — NOT NULL — Primary key — NOT NULL
- period (주기) — NOT NULL
- percent (달성률) — NOT NULL
- Room_id (id2) — NOT NULL — Foreign key → room.Room_id — NOT NULL
- User_id — NOT NULL — Foreign key → user.User_id — NOT NULL
room (Untitled2)
- Room_id (id) — NOT NULL — Primary key — NOT NULL
- duration (기간) — NOT NULL
- title (제목) — NOT NULL
- Create_time (생성시간) — NOT NULL
- Modify_time (수정시간) — NOT NULL
- Room_num (방코드) — NOT NULL
- Entry_fee (참가비) — NOT NULL
user (Untitled)
- User_id — NOT NULL — Primary key — NOT NULL
- password (비밀번호) — NOT NULL
- nickname (닉네임) — NOT NULL
- id (아이디) — NOT NULL
user_room (Untitled5)
- User_id — NOT NULL — Foreign key → user.User_id — NOT NULL
- Room_id (id2) — NOT NULL — Foreign key → room.Room_id — NOT NULL