skala-miniproject-kld

Tables (7)

knowledge_chunk

  • id — BIGINT — Primary key — NOT NULL — PK
  • knowledge_entry_id — BIGINT — Foreign key → knowledge_entry.id — NOT NULL
  • chunk_index — INT — NOT NULL
  • page_number — INT — p.18 인용용
  • content — TEXT — NOT NULL
  • embedding_ref — VARCHAR(200) — 벡터 스토어 ID 또는 vector 컬럼
  • token_count — INT

knowledge_entry

  • id — BIGINT — Primary key — NOT NULL — PK
  • source_type — VARCHAR(30) — NOT NULL — QA_PAIR / LECTURE_MATERIAL
  • reply_id — BIGINT — Foreign key → reply.id — 검증된 답변
  • lecture_material_id — BIGINT — Foreign key → lecture_material.id
  • title — VARCHAR(300)
  • content — TEXT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

lecture_material

  • id — BIGINT — Primary key — NOT NULL — PK
  • subject_id — BIGINT — Foreign key → subject.id — NOT NULL
  • uploader_id — BIGINT — Foreign key → users.id — NOT NULL — 업로드 교수
  • file_name — VARCHAR(255) — NOT NULL
  • storage_path — VARCHAR(500) — NOT NULL
  • mime_type — VARCHAR(100)
  • file_size — BIGINT
  • index_status — VARCHAR(20) — NOT NULL — PENDING / INDEXED / FAILED
  • indexed_at — DATETIME
  • created_at — DATETIME — NOT NULL

reply

  • id — BIGINT — Primary key — NOT NULL — PK
  • question_id — BIGINT — NOT NULL — 외부 참조 - question
  • reply_type — VARCHAR(30) — NOT NULL — AI_ANSWER / PROFESSOR_ANSWER / COMMENT
  • body — TEXT — NOT NULL
  • confidence_score — INT — AI_ANSWER만 0-100
  • confidence_reason — TEXT — 낮을 때 사유 배너 문구
  • model_name — VARCHAR(100)
  • is_accepted — BOOLEAN — NOT NULL — 교수 승인 또는 교수 작성 - 지식DB 적재 조건
  • 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
  • source_type — VARCHAR(30) — NOT NULL — LECTURE_MATERIAL / PAST_QUESTION
  • knowledge_chunk_id — BIGINT — Foreign key → knowledge_chunk.id — 강의자료 근거
  • ref_question_id — BIGINT — 과거 질문 근거 - 외부 참조
  • 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

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
  • class_group_id — BIGINT — 학생만, 반 정보 - 외부 참조
  • campus_region — VARCHAR(50) — 캠퍼스 지역정보
  • created_at — DATETIME — NOT NULL