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