81

Tables (15)

code_quiz_problems

  • id — serial4 — Primary key — NOT NULL
  • language — varchar(20) — NOT NULL
  • code_snippet — text — NOT NULL
  • question_text — text
  • option1 — varchar(100) — NOT NULL
  • option2 — varchar(100) — NOT NULL
  • option3 — varchar(100) — NOT NULL
  • option4 — varchar(100) — NOT NULL
  • correct_answer — int4 — NOT NULL
  • explanation — text
  • difficulty — int4
  • subject_id — int4 — Foreign key → subject.id
  • created_at — timestamp

learning_card

  • id — bigserial — Primary key — NOT NULL
  • subject_id — int8 — Foreign key → subject.id — NOT NULL
  • card_type — varchar(32) — NOT NULL
  • front_text — varchar(4000) — NOT NULL
  • back_text — varchar(4000)
  • answer_text — varchar(2000)
  • explanation — varchar(4000)
  • is_ai_generated — bool — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

login_history

  • id — bigserial — Primary key — NOT NULL
  • user_id — int8 — Foreign key → users.id — NOT NULL
  • login_date — date — NOT NULL
  • logged_in_at — timestamptz — NOT NULL

objective_quiz_problems

  • id — int8 — Primary key — NOT NULL
  • subject_id — int4 — Foreign key → subject.id
  • question — varchar(1000) — NOT NULL
  • answer — varchar(500) — NOT NULL
  • explanation — varchar(2000)
  • difficulty — int4
  • is_ai_generated — bool — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • option1 — varchar(500) — 보기 1 (주관식 퀴즈 선택지)
  • option2 — varchar(500) — 보기 2 (주관식 퀴즈 선택지)
  • option3 — varchar(500) — 보기 3 (주관식 퀴즈 선택지)
  • option4 — varchar(500) — 보기 4 (주관식 퀴즈 선택지)
  • option5 — varchar(500) — 보기 5 (주관식 퀴즈 선택지)
  • question_text — varchar(3000)

problem

  • id — bigserial — Primary key — NOT NULL
  • subject_id — int4 — Foreign key → subject.id — NOT NULL
  • question — varchar(1000) — NOT NULL
  • answer — varchar(500) — NOT NULL
  • explanation — varchar(2000)
  • type — varchar(255) — NOT NULL
  • difficulty — int4
  • option1 — varchar(255)
  • option2 — varchar(255)
  • option3 — varchar(255)
  • option4 — varchar(255)
  • option5 — varchar(255)
  • is_ai_generated — bool — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

programming_language_problems

  • id — bigserial — Primary key — NOT NULL
  • subject_id — int4 — Foreign key → subject.id
  • prog_language — varchar(64) — NOT NULL
  • question — varchar(1000) — NOT NULL
  • answer — varchar(500) — NOT NULL
  • explanation — varchar(2000)
  • difficulty — int4
  • is_ai_generated — bool — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • option1 — varchar(500)
  • option2 — varchar(500)
  • option3 — varchar(500)
  • option4 — varchar(500)
  • option5 — varchar(500)
  • isAiGenerated — bool
  • question_text — varchar(3000)

statistics

  • id — bigserial — Primary key — NOT NULL
  • user_id — int8 — Foreign key → users.id — NOT NULL
  • is_correct — bool — NOT NULL
  • problem_type — varchar(32) — NOT NULL
  • reference_id — int8 — NOT NULL
  • submitted_at — timestamp

study_session

  • id — bigserial — Primary key — NOT NULL
  • user_id — int8 — Foreign key → users.id — NOT NULL
  • subject_id — int4 — Foreign key → subject.id
  • session_type — varchar(32)
  • status — varchar(32)
  • session_key — varchar(255)
  • google_id — varchar(255)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

study_session_item

  • id — bigserial — Primary key — NOT NULL
  • session_id — int8 — Foreign key → study_session.id — NOT NULL
  • item_type — varchar(32) — NOT NULL
  • reference_id — int8 — NOT NULL
  • subject_id — int8 — Foreign key → subject.id — NOT NULL
  • item_order — int4 — NOT NULL
  • presented_at — timestamp — NOT NULL
  • answered_at — timestamp
  • is_answered — bool — NOT NULL
  • is_correct — bool
  • user_submitted_answer — varchar(4000)
  • bookmarked_wrong — bool — NOT NULL

subject

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — varchar(255)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • problem_type — varchar(255) — '과목의 문제 유형: OBJECTIVE(객관식) SUBJECTIVE(주관식), MIXED(혼합)',

user_answer

  • id — bigserial — Primary key — NOT NULL
  • user_id — int8 — Foreign key → users.id — NOT NULL
  • session_id — varchar(255)
  • item_type — varchar(32) — NOT NULL
  • reference_id — int8 — NOT NULL
  • submitted_answer — varchar(4000)
  • is_correct — bool — NOT NULL
  • submitted_at — timestamp — NOT NULL

user_statistics

  • id — bigserial — Primary key — NOT NULL
  • user_id — int8 — Foreign key → users.id — NOT NULL
  • subject_id — int8 — Foreign key → subject.id — NOT NULL
  • branch — varchar(32) — NOT NULL
  • total_attempted — int4 — NOT NULL
  • correct_count — int4 — NOT NULL
  • incorrect_count — int4 — NOT NULL
  • last_studied_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

users

  • id — bigserial — Primary key — NOT NULL
  • google_id — varchar(255)
  • email — varchar(255) — NOT NULL
  • password — varchar(255)
  • username — varchar(255) — NOT NULL
  • nickname — varchar(255)
  • role — varchar(32) — NOT NULL
  • trial_started_at — timestamp — NOT NULL
  • trial_expires_at — timestamp — NOT NULL
  • subscription_started_at — timestamp
  • subscription_expires_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

wrong_answer_bookmark

  • id — bigserial — Primary key — NOT NULL
  • user_id — int8 — Foreign key → users.id — NOT NULL
  • item_type — varchar(32) — NOT NULL
  • reference_id — int8 — NOT NULL
  • bookmarked_at — timestamp
  • review_count — int4

wrong_answer_count

  • id — bigserial — Primary key — NOT NULL
  • user_id — int8 — Foreign key → users.id — NOT NULL
  • item_type — varchar(32) — NOT NULL — '문제 유형 (OBJECTIVE SUBJECTIVE, PROGRAMMING_LANGUAGE)',
  • reference_id — int8 — Foreign key → problem.id — NOT NULL — 문제 ID
  • wrong_count — int4 — NOT NULL — 오답 횟수
  • last_wrong_at — timestamp — 마지막 오답 시간
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL