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)