Database 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)