temp_algobaro

Tables (3)

Room (Untitled3)

  • 방번호 (room_id) — bigint — Primary key — NOT NULL
  • 방제목 (room_name) — varchar(255)
  • 최대인원 (room_count) — bigint
  • 회원id (user_id) — bigint — Foreign key → User.회원id — NOT NULL

Solve (Untitled2)

  • 문제번호 (problem_id) — bigint — Primary key — NOT NULL
  • 플랫폼 (platform) — varchar(255)
  • 풀이여부 (is_solved) — tinyint
  • 회원id (id) — bigint — Foreign key → User.회원id — NOT NULL

User (Untitled)

  • 회원id (id) — bigint — Primary key — NOT NULL
  • 닉네임 (nickname) — varchar(255)
  • 이메일 (email) — varchar(255)