Skip to content

Database Schema

Jump to bottom
Youjin Lee edited this page Jun 12, 2021 · 1 revision

schema

users

  • id / int / not null / primary key / auto_increment
  • email / string / not null
  • password / string / not null
  • nickname / string / not null
  • profile_image / int / foreign key (images.id)
  • room_id / int / foreign key (rooms.id)

followers

  • followed_id / int / foreign key (users.id)
  • following_id / int / foreign key (users.id)

follwings

  • following_id / int / foreign key (users.id)
  • followed_id / int / foreign key (users.id)

images

  • id / int / not null / primary key / auto_increment
  • 이미지 / mediumblob / not null

rooms

  • id / int / not null / primary key / auto_increment
  • room_name / string
  • room_pw / string
  • limit_time / string
  • answer / string

guests

  • id / int / not null / primary key / auto_increment
  • random_name / string
  • room_id / int / foreign eky (rooms.id)
Clone this wiki locally