hompocha

Tables (4)

Room (방정보)

  • Key (id) — Primary key — NOT NULL
  • 방제목 (title)
  • 접속인원 (usercount)

Roomlist (방목록)

  • Key (id) — Primary key — NOT NULL
  • Key (room_id) — Foreign key → Room.Key — NOT NULL

User (유저)

  • Key (id) — Primary key — NOT NULL
  • 유저네임 (username)
  • 비밀번호 (password)
  • 별명 (nickname)

User_Room (유저_방정보)

  • Key (id) — Primary key — NOT NULL
  • Key (room_id) — Foreign key → Room.Key — NOT NULL
  • Key (user_id) — Foreign key → User.Key — NOT NULL