[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