SummarAI

Tables (6)

public.chat_history (채팅기록)

  • 채팅ID (chat_id) — Primary Key — Primary key — NOT NULL
  • 세션ID (session_id) — Foreign Key — Foreign key → public.session.세션ID — NOT NULL
  • 역할 (role) — NOT NULL — NOT NULL
  • 메시지 (message) — NULL
  • 타임스탬프 (timestamp) — default : current_timestep
  • 이전채팅ID (parent_message_id) — chat_history(chat_id)
  • 문서ID (context_docs) — NULL

public.documents (문서)

  • 문서ID (doc_id) — Primary Key — Primary key — NOT NULL
  • 논문ID (paper_id) — Foreing Key — Foreign key → public.papers_info.논문ID — NOT NULL
  • 세션ID (session_id) — Foreign Key — Foreign key → public.papers_info.세션ID — NOT NULL
  • 페이지 (page) — NULL
  • 내용 (content) — NULL
  • 임베딩값 (embedding) — NOT NULL
  • 생성일시 (created_at) — default : current_timestep
  • 논문_index (idx_session_paper) — (session_id, paper_id)
  • 벡터_index (vector_idx) — hnsw (embedding cdb_admin.vector_cosine_ops)

public.external_papers (외부논문)

  • 외부논문id (external_paper_id) — Primary Key — Primary key — NOT NULL
  • 세션ID (session_id) — Foreign Key — Foreign key → public.session.세션ID — NOT NULL
  • 논문ID (paper_id2) — Foreign Key — Foreign key → public.papers_info.논문ID — NOT NULL
  • 논문 제목 (title) — NOT NULL — NOT NULL
  • 저자 (author) — NULL
  • 개요 (abstract) — NULL
  • 발행년도 (publication_year) — NULL
  • 사용API (source) — NOT NULL
  • 주소 (url) — NULL
  • 임베딩값 (embedding) — NOT NULL
  • 생성일시 (created_at) — default : current_timestep
  • 세션레퍼 (idx_session_reference) — (session_id, paper_id)
  • 백터_index (vector_idx) — hnsw (embedding cdb_admin.vector_cosine_ops)

public.papers_info (논문정보)

  • 논문ID (paper_id) — Primary Key — Primary key — NOT NULL
  • 세션ID (session_id) — Foreign Key — Foreign key → public.session.세션ID — NOT NULL
  • 제목 (title) — NOT NULL — NOT NULL
  • 저자 (author) — NULL
  • 업로드일시 (uploaded_at) — current_timestamp

public.search_history (검색기록)

  • 검색ID (search_id) — Primary Key — Primary key — NOT NULL
  • 세션ID (session_id) — Foreign Key — Foreign key → public.session.세션ID — NOT NULL
  • 쿼리 (query) — NULL — NOT NULL
  • 타임스탬프 (timestamp) — default : current_timestep
  • 응답시간 (response_time) — NULL
  • 결과 수 (results_count) — NULL

public.session (세션)

  • 세션ID (session_id) — Primary Key — Primary key — NOT NULL
  • 생성일시 (created_at) — current_timestamp
  • 마지막 접근 (last_accessed) — NULL
  • 활동여부 (is_active) — True