종프
테이블 (8)
chunks
- chunk_id — UUID
- session_id — UUID — 외래 키 → sessions.session_id — NOT NULL
- chunk_index — INT — NOT NULL
- start_time — REAL — NOT NULL
- end_time — REAL — NOT NULL
- chunk_text — TEXT — NOT NULL
- embedding — VECTOR(1024)
- created_at — TIMESTAMP — NOT NULL
concept_requests
- request_id — UUID
- user_id — UUID — 외래 키 → users.user_id — NOT NULL
- session_id — UUID — 외래 키 → sessions.session_id — NOT NULL
- clicked_text — VARCHAR(255) — NOT NULL
- normalized_term — VARCHAR(255)
- request_time — REAL — NOT NULL
- request_type — VARCHAR(50)
- status — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
courses
- course_id — UUID
- user_id — UUID — 외래 키 → users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- type — VARCHAR(50)
- description — TEXT
- created_at — TIMESTAMP — NOT NULL
explanation_chunks
- explanation_chunk_id — UUID
- explanation_id — UUID — 외래 키 → explanations.explanation_id — NOT NULL
- chunk_id — UUID — 외래 키 → chunks.chunk_id — NOT NULL
- similarity_score — REAL
- rank_order — INT
- quoted_text — TEXT
explanations
- explanation_id — UUID
- request_id — UUID — 외래 키 → concept_requests.request_id — NOT NULL
- answer_text — TEXT — NOT NULL
- source_links — TEXT
- model_name — VARCHAR(100)
- latency_ms — INT
- created_at — TIMESTAMP — NOT NULL
sessions
- session_id — UUID
- course_id — UUID — 외래 키 → courses.course_id — NOT NULL
- session_date — DATE — NOT NULL
- title — VARCHAR(255) — NOT NULL
- audio_path — TEXT
- duration_sec — INT
- status — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
transcripts
- transcript_id — UUID
- session_id — UUID — 외래 키 → sessions.session_id — NOT NULL
- segment_index — INT — NOT NULL
- start_time — REAL — NOT NULL
- end_time — REAL — NOT NULL
- original_text — TEXT — NOT NULL
- corrected_text — TEXT
- confidence — REAL
- created_at — TIMESTAMP — NOT NULL
users
- user_id — UUID
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL