온점
테이블 (15)
competency_scores
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- competency_type — ENUM('factual','inferential','critical','vocabulary','logical') — NOT NULL
- score — DECIMAL(5,2) — NOT NULL
- level — ENUM('초급','중급','고급','심화') — NOT NULL
- delta — DECIMAL(5,2) — NOT NULL
- measured_at — DATETIME — NOT NULL
curricula
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- diagnostic_id — BIGINT — 외래 키 → diagnostic_results.id — NOT NULL
- status — ENUM('active','paused','completed') — NOT NULL
- current_stage — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
curriculum_items
- id — BIGINT — 기본 키 — NOT NULL
- curriculum_id — BIGINT — 외래 키 → curricula.id — NOT NULL
- problem_id — BIGINT — 외래 키 → problems.id — NOT NULL
- stage — INT — NOT NULL
- order_index — INT — NOT NULL
- status — ENUM('pending','in_progress','completed','skipped') — NOT NULL
- scheduled_at — DATETIME
- completed_at — DATETIME
diagnostic_results
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- theta — DECIMAL(5,3) — NOT NULL
- factual_score — INT — NOT NULL
- inferential_score — INT — NOT NULL
- critical_score — INT — NOT NULL
- vocabulary_score — INT — NOT NULL
- logical_score — INT — NOT NULL
- level — INT — NOT NULL
- created_at — DATETIME — NOT NULL
email_verifications
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- otp_code — VARCHAR(6) — NOT NULL
- is_used — BOOLEAN — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
highlights
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- problem_id — BIGINT — 외래 키 → problems.id — NOT NULL
- start_offset — INT — NOT NULL
- end_offset — INT — NOT NULL
- color — ENUM('yellow','blue','pink') — NOT NULL
- created_at — DATETIME — NOT NULL
knowledge_tracing
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- competency_type — ENUM('factual','inferential','critical','vocabulary','logical') — NOT NULL
- p_know — DECIMAL(5,4) — NOT NULL
- p_learn — DECIMAL(5,4) — NOT NULL
- p_slip — DECIMAL(5,4) — NOT NULL
- p_guess — DECIMAL(5,4) — NOT NULL
- updated_at — DATETIME — NOT NULL
problem_choices
- id — BIGINT — 기본 키 — NOT NULL
- problem_id — BIGINT — 외래 키 → problems.id — NOT NULL
- choice_number — INT — NOT NULL
- choice_text — TEXT — NOT NULL
- is_correct — BOOLEAN — NOT NULL
problem_keywords
- id — BIGINT — 기본 키 — NOT NULL
- problem_id — BIGINT — 외래 키 → problems.id — NOT NULL
- keyword — VARCHAR(100) — NOT NULL
- weight — INT — NOT NULL
problems
- id — BIGINT — 기본 키 — NOT NULL
- passage_text — TEXT — NOT NULL
- question_text — TEXT — NOT NULL
- problem_type — ENUM('multiple_choice','short_answer') — NOT NULL
- reading_type — ENUM('factual','inferential','critical','creative') — NOT NULL
- difficulty — INT — NOT NULL
- model_answer — TEXT — NOT NULL
- vector_indexed — BOOLEAN — NOT NULL
- vector_index_status — ENUM('pending','indexing','done') — NOT NULL
- created_at — DATETIME — NOT NULL
refresh_tokens
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- token_hash — VARCHAR(255) — NOT NULL
- device_info — VARCHAR(255)
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
responses
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- problem_id — BIGINT — 외래 키 → problems.id — NOT NULL
- curriculum_item_id — BIGINT — 외래 키 → curriculum_items.id
- answer_text — TEXT — NOT NULL
- response_time_sec — INT — NOT NULL
- raw_score — INT — NOT NULL
- final_score — INT — NOT NULL
- feedback_text — TEXT
- error_type — VARCHAR(50)
- scoring_basis — TEXT
- attempt_number — INT — NOT NULL
- created_at — DATETIME — NOT NULL
review_schedules
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- problem_id — BIGINT — 외래 키 → problems.id — NOT NULL
- review_count — INT — NOT NULL
- next_review_at — DATETIME — NOT NULL
- last_reviewed_at — DATETIME
token_blacklist
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- token_hash — VARCHAR(255) — NOT NULL
- reason — ENUM('logout','force_logout','password_reset') — NOT NULL
- invalidated_at — DATETIME — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash (password) — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — ENUM('GUEST','STUDENT','ADMIN') — NOT NULL
- daily_goal — INT — NOT NULL
- email_verified — BOOLEAN — NOT NULL
- alarm_enabled — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL