종프

테이블 (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