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