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