온점

테이블 (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