[INT2] 프로젝트 ERD

테이블 (12)

answer_feedback

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • message_id — BIGINT — 외래 키 → messages.id — NOT NULL
  • rating — VARCHAR(20)
  • report_type — VARCHAR(30)
  • created_at — TIMESTAMPTZ — NOT NULL

chunks

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • file_id — BIGINT — 외래 키 → files.id — NOT NULL
  • chunk_index — INT — NOT NULL
  • content — TEXT — NOT NULL
  • page — INT
  • token_count — INT
  • embedding — vector(1536)
  • created_at — TIMESTAMPTZ — NOT NULL

conversations

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • title — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL

file_metadata

  • file_id — BIGINT — 외래 키 → files.id — NOT NULL
  • doc_type — VARCHAR(100)
  • summary — TEXT
  • tags — TEXT
  • entities — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

files

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • folder_id — BIGINT — 외래 키 → folders.id
  • name — VARCHAR(255) — NOT NULL
  • s3_key — VARCHAR(512) — NOT NULL
  • file_type — VARCHAR(50)
  • size_bytes — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • error_message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

folders

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • parent_id — BIGINT — 외래 키 → folders.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

message_citations

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • message_id — BIGINT — 외래 키 → messages.id — NOT NULL
  • chunk_id — BIGINT — 외래 키 → chunks.id
  • file_id — BIGINT — 외래 키 → files.id
  • page — INT
  • created_at — TIMESTAMPTZ — NOT NULL

messages

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • conversation_id — BIGINT — 외래 키 → conversations.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • query_type — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL

processing_jobs

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • file_id — BIGINT — 외래 키 → files.id — NOT NULL
  • job_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • attempts — INT — NOT NULL
  • error_message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ

query_failure_logs

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • message_id — BIGINT — 외래 키 → messages.id
  • failure_type — VARCHAR(30) — NOT NULL
  • detail — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

reorg_snapshots

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • snapshot_json — JSONB — NOT NULL
  • description — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL

sanctions

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • action — VARCHAR(20) — NOT NULL
  • reason — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL