80
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
- 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