p07-erd

Tables (8)

chat_logs

  • id — SERIAL — Primary key — NOT NULL
  • session_id — UUID — Foreign key → sessions.id — NOT NULL
  • user_id — UUID — Foreign key → users.id
  • message — TEXT
  • role — VARCHAR(10)
  • created_at — TIMESTAMPTZ — NOT NULL

doc_chunks

  • id — SERIAL — Primary key — NOT NULL
  • doc_id — INT — Foreign key → document.id — NOT NULL
  • chunk_index — INT — 문서 내 위치
  • heading — TEXT — 섹션 제목
  • content — TEXT
  • fts_vector — TSVECTOR — GIN인덱스 적용
  • created_at — TIMESTAMPTZ — NOT NULL

document

  • id — SERIAL — Primary key — NOT NULL
  • title — TEXT
  • source_url — TEXT
  • category — VARCHAR(20)
  • status — VARCHAR(20) — 색인 상태
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ

feedback

  • id — SERIAL — Primary key — NOT NULL
  • chat_logs_id — INT — Foreign key → chat_logs.id — NOT NULL
  • rating — VARCHAR(10) — thumb_up/down
  • comment — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

search_logs

  • id — SERIAL — Primary key — NOT NULL
  • session_id — UUID — Foreign key → sessions.id
  • query — TEXT — NOT NULL
  • matched_chunks_json — JSONB — 매치된 청크 ID + 점수 배열
  • duration_ms — INT — 검색 소요 시간
  • created_at — TIMESTAMPTZ — NOT NULL

sessions

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id
  • title — TEXT — 대화 제목
  • created_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ

unanswered_questions

  • id — SERIAL — Primary key — NOT NULL
  • question — TEXT — NOT NULL
  • reason — VARCHAR(20) — 범위외/관련문서없음
  • status — VARCHAR(20) — unresolved/resolved/dismissed
  • frequency — INT — NOT NULL — 무응답 된 횟수
  • resolved_by — INT — Foreign key → document.id — 근거 문서
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ

users

  • id — UUID — Primary key — NOT NULL
  • email — NOT NULL — unique
  • name — VARCHAR(20)
  • pwd_hash — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL