first erd
Tables (3)
room (룸)
- 룸ID (room_id) — NOT NULL — Primary key — NOT NULL
- 룸 이름 (room_name) — NOT NULL
- 카테고리 (category) — NOT NULL
- 생성시각 (created_at) — NOT NULL
- 학습 요약노트 (study_summary) — NULL — NOT NULL
user (회원)
- 회원ID (user_id) — NOT NULL — Primary key — NOT NULL
- 닉네임 (nickname) — NOT NULL
- 레벨 (level) — NOT NULL
- 경험치 (exp) — NOT NULL
- 부둥 (boodoong) — NOT NULL
user - room host (사용자 - 룸 관리자)
- 회원ID (user_id) — NOT NULL — Foreign key → user.회원ID — NOT NULL
- 룸ID (room_id) — NOT NULL — Foreign key → room.룸ID — NOT NULL