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