전종설 최종 보고서
테이블 (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