CodeBogo

Tables (5)

problem_history (문제기록)

  • id — Int — Primary key — NOT NULL
  • selected_answer — varchar(500)
  • correct — varchar(50)
  • earned_point — varchar(50)
  • solved_at — time
  • user_id — Int — Foreign key → users.id — NOT NULL
  • problems_id — Int — Foreign key → problems.id — NOT NULL
  • quiz_sessions_id — Int — Foreign key → quiz_sessions.id — NOT NULL

problems (문제)

  • id — Int — Primary key — NOT NULL
  • language — varchar(50)
  • title — varchar(50)
  • code — Int
  • option_a ~ option_d — varchar(50)
  • answer — varchar(500)
  • feedback — varchar(500)
  • correct_code — Int
  • point — varchar(50)

quiz_session_problems (랜덤문제)

  • id — Int — Primary key — NOT NULL
  • order_no — Int
  • quiz_sessions_id — Int — Foreign key → quiz_sessions.id — NOT NULL
  • probles_id — Int — Foreign key → problems.id — NOT NULL

quiz_sessions (퀴즈세션)

  • id — Int — Primary key — NOT NULL
  • total_count — varchar(50)
  • current_index — Int
  • correct_count — varchar(50)
  • earned_point — Int
  • status — boolean
  • started_at — time
  • finished_at — time
  • users_id — Int — Foreign key → users.id — NOT NULL

users (유저)

  • id — Int — Primary key — NOT NULL
  • nickname — varchar(50)
  • point — varchar(50)
  • streak — varchar(50)
  • last_solved_date — varchar(50)