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