skala-miniproject
Tables (20)
ai_job
- id — BIGINT — Primary key — NOT NULL — PK
- job_type — VARCHAR(40) — NOT NULL — RAG_ANSWER / QUIZ_GEN / WEAKNESS_REPORT / CURRICULUM_REPORT
- target_type — VARCHAR(40)
- target_id — BIGINT
- status — VARCHAR(20) — NOT NULL — PENDING / RUNNING / SUCCESS / FAILED
- requested_by — BIGINT — Foreign key → users.id
- error_message — TEXT
- requested_at — DATETIME — NOT NULL
- finished_at — DATETIME
class_session
- id — BIGINT — Primary key — NOT NULL — PK
- subject_id — BIGINT — Foreign key → subject.id — NOT NULL
- lead_professor_id — BIGINT — Foreign key → users.id — 전임교수
- lab_professor_id — BIGINT — Foreign key → users.id — 실습교수
- session_date — DATE — NOT NULL
- start_time — TIME — 09:00
- end_time — TIME — 18:00
- delivery_mode — VARCHAR(20) — ONLINE / OFFLINE
- room — VARCHAR(30) — 204호
concept
- id — BIGINT — Primary key — NOT NULL — PK
- name — VARCHAR(200) — NOT NULL — JPA 연관관계 · fetch 전략
- subject_id — BIGINT — Foreign key → subject.id — 추천 복습 차시
- description — TEXT
- is_active — BOOLEAN — NOT NULL
curriculum_report
- id — BIGINT — Primary key — NOT NULL — PK
- subject_id — BIGINT — Foreign key → subject.id — NOT NULL
- period_start — DATE
- period_end — DATE
- question_count — INT — NOT NULL
- unresolved_count — INT — NOT NULL
- ai_auto_rate — DECIMAL(5, 2) — AI 자동 처리율 88%
- repeat_pattern — TEXT — 반복 질문 개념
- improvement_suggestion — TEXT — AI 개선안
- status — VARCHAR(20) — NOT NULL — DRAFT / REVIEWED
- reviewed_by — BIGINT — Foreign key → users.id
- generated_at — DATETIME — NOT NULL
question
- id — BIGINT — Primary key — NOT NULL — PK
- code — VARCHAR(20) — NOT NULL — Q-812 표시용
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- subject_id — BIGINT — Foreign key → subject.id — NOT NULL — 과목 select - 통계 기준축
- class_session_id — BIGINT — Foreign key → class_session.id — 질문 버튼 누른 일정
- title — VARCHAR(300) — NOT NULL
- body — TEXT — NOT NULL
- status — VARCHAR(30) — NOT NULL — AI_GENERATING / AI_ANSWERED / PENDING_REVIEW / PROFESSOR_ANSWERED
- ai_confidence_score — INT — 0-100 대표 신뢰도
- reply_count — INT — NOT NULL — 목록의 답변 N
- view_count — INT — NOT NULL
- resolved_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
question_concept
- id — BIGINT — Primary key — NOT NULL — PK
- question_id — BIGINT — Foreign key → question.id — NOT NULL
- concept_id — BIGINT — Foreign key → concept.id — NOT NULL
- mapped_by — VARCHAR(20) — NOT NULL — TAG_RULE / AI / PROFESSOR
- confidence — DECIMAL(5, 4)
question_similarity
- id — BIGINT — Primary key — NOT NULL — PK
- question_id — BIGINT — Foreign key → question.id — NOT NULL
- similar_question_id — BIGINT — Foreign key → question.id — NOT NULL
- score — DECIMAL(5, 4) — NOT NULL
- computed_at — DATETIME — NOT NULL
question_tag
- id — BIGINT — Primary key — NOT NULL — PK
- question_id — BIGINT — Foreign key → question.id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.id — NOT NULL
quiz_attempt
- id — BIGINT — Primary key — NOT NULL — PK
- quiz_session_id — BIGINT — Foreign key → quiz_session.id — NOT NULL
- quiz_item_id — BIGINT — Foreign key → quiz_item.id — NOT NULL
- item_index — INT — 2 / 5
- submitted_answer — TEXT
- is_correct — BOOLEAN
- answered_at — DATETIME
quiz_item
- id — BIGINT — Primary key — NOT NULL — PK
- concept_id — BIGINT — Foreign key → concept.id — NOT NULL
- source_question_id — BIGINT — Foreign key → question.id — AI 생성 근거 질문
- stem — TEXT — NOT NULL
- explanation — TEXT — 오답 해설
- created_at — DATETIME — NOT NULL
quiz_option
- id — BIGINT — Primary key — NOT NULL — PK
- quiz_item_id — BIGINT — Foreign key → quiz_item.id — NOT NULL
- option_label — VARCHAR(5) — NOT NULL — A / B / C / D
- option_index — INT — NOT NULL
- content — TEXT — NOT NULL
- is_correct — BOOLEAN — NOT NULL
quiz_session
- id — BIGINT — Primary key — NOT NULL — PK
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- weakness_report_id — BIGINT — Foreign key → weakness_report.id — 약점 기반 출제
- concept_id — BIGINT — Foreign key → concept.id
- status — VARCHAR(20) — NOT NULL — IN_PROGRESS / COMPLETED / ABANDONED
- total_count — INT — NOT NULL — 5문항
- correct_count — INT — NOT NULL — 4
- started_at — DATETIME — NOT NULL
- submitted_at — DATETIME
reply
- id — BIGINT — Primary key — NOT NULL — PK
- question_id — BIGINT — Foreign key → question.id — NOT NULL
- reply_type — VARCHAR(30) — NOT NULL — AI_ANSWER / PROFESSOR_ANSWER / COMMENT
- author_id — BIGINT — Foreign key → users.id — AI면 null
- body — TEXT — NOT NULL
- confidence_score — INT — AI_ANSWER만 0-100
- confidence_reason — TEXT — 낮을 때 사유 배너 문구
- model_name — VARCHAR(100)
- is_accepted — BOOLEAN — NOT NULL — 교수 승인 또는 교수 작성
- reviewed_by — BIGINT — Foreign key → users.id
- reviewed_at — DATETIME
- is_edited — BOOLEAN — NOT NULL — 수정됨 표시
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
reply_source
- id — BIGINT — Primary key — NOT NULL — PK
- reply_id — BIGINT — Foreign key → reply.id — NOT NULL
- source_type — VARCHAR(30) — NOT NULL — LECTURE_MATERIAL / PAST_QUESTION
- knowledge_chunk_id — BIGINT — 강의자료 근거 - 지식DB 테이블 미포함 상태
- ref_question_id — BIGINT — Foreign key → question.id — 과거 질문 근거
- display_label — VARCHAR(300) — 강의자료 4주차 JPA 연관관계 p.18
- page_number — INT
- similarity_score — DECIMAL(5, 4)
- rank_no — INT — rank는 예약어라 rank_no
subject
- id — BIGINT — Primary key — NOT NULL — PK
- name — VARCHAR(200) — NOT NULL — 웹 서비스 개발 mini-Project
- week_no — INT — 4주차 - 주차별 집계 · 복습 추천
- sequence — INT — 진도 순서 - 미학습 개념 필터
- description — TEXT
- is_active — BOOLEAN — NOT NULL
tag
- id — BIGINT — Primary key — NOT NULL — PK
- name — VARCHAR(50) — NOT NULL — jpa / spring boot / n+1
- usage_count — INT — NOT NULL — 자동완성 정렬
users
- id — BIGINT — Primary key — NOT NULL — PK
- login_id — VARCHAR(50) — NOT NULL — 아이디 로그인
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL — STUDENT / PROFESSOR
- campus_region — VARCHAR(50) — 캠퍼스 지역정보
- created_at — DATETIME — NOT NULL
weakness_evidence
- id — BIGINT — Primary key — NOT NULL — PK
- weakness_item_id — BIGINT — Foreign key → weakness_item.id — NOT NULL
- question_id — BIGINT — Foreign key → question.id — NOT NULL — 근거 질문
weakness_item
- id — BIGINT — Primary key — NOT NULL — PK
- weakness_report_id — BIGINT — Foreign key → weakness_report.id — NOT NULL
- concept_id — BIGINT — Foreign key → concept.id — NOT NULL
- status — VARCHAR(20) — NOT NULL — WEAK 취약 / IMPROVING 개선중 / NOT_ATTEMPTED 미응시
- question_count — INT — NOT NULL
- quiz_accuracy — DECIMAL(5, 2)
- rank_no — INT — 카드 정렬 순서
weakness_report
- id — BIGINT — Primary key — NOT NULL — PK
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- period_start — DATE
- period_end — DATE
- total_question_count — INT — NOT NULL — 내 질문 6건
- weak_concept_count — INT — NOT NULL — 취약 개념 3개
- avg_ai_confidence — INT — 평균 AI 신뢰도 83
- quiz_accuracy — DECIMAL(5, 2) — 퀴즈 정답률 67%
- summary_text — TEXT — AI 요약 확장 슬롯
- generated_at — DATETIME — NOT NULL