전종설 최종 보고서

테이블 (14)

activity_logs

  • id — VARCHAR(255)
  • user_id — VARCHAR(255) — 외래 키 → users.id — NOT NULL
  • type — activity_type — NOT NULL
  • grade_id — VARCHAR(255) — 외래 키 → grades.id — NOT NULL
  • subject_id — VARCHAR(255) — 외래 키 → subjects.id — NOT NULL
  • subject_name — VARCHAR(255) — NOT NULL
  • material_id — VARCHAR(255) — 외래 키 → materials.id — NOT NULL
  • material_title — VARCHAR(255) — NOT NULL
  • page — INTEGER
  • title — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

goals

  • id — VARCHAR(255)
  • user_id — VARCHAR(255) — 외래 키 → users.id — NOT NULL
  • daily_quiz_goal — INTEGER — NOT NULL
  • weekly_quiz_goal — INTEGER — NOT NULL
  • daily_material_goal — INTEGER — NOT NULL
  • weekly_material_goal — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

grades

  • id — VARCHAR(255)
  • year — INTEGER — NOT NULL
  • term — INTEGER — NOT NULL
  • user_id — VARCHAR(255) — 외래 키 → users.id — NOT NULL
  • is_current — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

jobs

  • id — VARCHAR(255)
  • type — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • priority — INTEGER — NOT NULL
  • material_id — VARCHAR(255) — 외래 키 → materials.id
  • page — INTEGER
  • payload — JSONB
  • attempts — INTEGER — NOT NULL
  • max_attempts — INTEGER — NOT NULL
  • locked_at — TIMESTAMP
  • locked_by — VARCHAR(255)
  • last_error — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

material_page_texts

  • id — VARCHAR(255)
  • material_id — VARCHAR(255) — 외래 키 → materials.id — NOT NULL
  • page — INTEGER — NOT NULL
  • text — TEXT — NOT NULL
  • char_count — INTEGER — NOT NULL
  • method — VARCHAR(255)
  • status — VARCHAR(255) — NOT NULL
  • error — TEXT
  • extracted_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

material_summaries

  • id — VARCHAR(255)
  • material_id — VARCHAR(255) — 외래 키 → materials.id — NOT NULL
  • source_hash — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • provider — VARCHAR(255)
  • model — VARCHAR(255)
  • prompt_version — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

materials

  • id — VARCHAR(255)
  • subject_id — VARCHAR(255) — 외래 키 → subjects.id — NOT NULL
  • week — INTEGER — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • storage_path — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notes

  • id — VARCHAR(255)
  • material_id — VARCHAR(255) — 외래 키 → materials.id — NOT NULL
  • page — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

quiz_answers

  • id — VARCHAR(255)
  • attempt_id — VARCHAR(255) — 외래 키 → quiz_attempts.id — NOT NULL
  • quiz_item_id — VARCHAR(255) — 외래 키 → quiz_items.id — NOT NULL
  • response — JSONB — NOT NULL
  • is_correct — BOOLEAN
  • earned — INTEGER
  • feedback — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

quiz_attempts

  • id — VARCHAR(255)
  • user_id — VARCHAR(255) — 외래 키 → users.id — NOT NULL
  • quiz_set_id — VARCHAR(255) — 외래 키 → quiz_sets.id — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • score — INTEGER
  • max_score — INTEGER
  • started_at — TIMESTAMP — NOT NULL
  • submitted_at — TIMESTAMP
  • graded_at — TIMESTAMP

quiz_items

  • id — VARCHAR(255)
  • quiz_set_id — VARCHAR(255) — 외래 키 → quiz_sets.id — NOT NULL
  • item_order — INTEGER — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • question — TEXT — NOT NULL
  • choices — JSONB
  • answer_key — JSONB — NOT NULL
  • explanation — TEXT
  • topic — VARCHAR(255)
  • points — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

quiz_sets

  • id — VARCHAR(255)
  • material_id — VARCHAR(255) — 외래 키 → materials.id — NOT NULL
  • summary_id — VARCHAR(255) — 외래 키 → material_summaries.id
  • source_hash — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255)
  • provider — VARCHAR(255)
  • model — VARCHAR(255)
  • prompt_version — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

subjects

  • id — VARCHAR(255)
  • name — VARCHAR(255) — NOT NULL
  • grade_id — VARCHAR(255) — 외래 키 → grades.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • is_current — BOOLEAN — NOT NULL

users

  • id — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL