상속자들
테이블 (7)
chat_messages (채팅)
- id — BIGSERIAL — 기본 키 — NOT NULL
- session_id — BIGINT — 외래 키 → chat_sessions.id — NOT NULL
- role — message_role — NOT NULL
- content — TEXT — NOT NULL
- embedding — VECTOR(1024)
- created_at — TIMESTAMPTZ — NOT NULL
chat_sessions (채팅세션)
- id — BIGSERIAL — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id
- title — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
chunks (청크)
- id — BIGSERIAL — 기본 키 — NOT NULL
- document_id — BIGINT — 외래 키 → documents.id — NOT NULL
- page — INT — NOT NULL
- keyword — TEXT
- content — TEXT — NOT NULL
- n_chars — INT
- embedding — VECTOR(1024)
- created_at — TIMESTAMPTZ — NOT NULL
documents (문서)
- id — BIGSERIAL — 기본 키 — NOT NULL
- file_name — TEXT — NOT NULL
- category — document_category — NOT NULL
- bank — TEXT
- contract_type — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
message_sources (참고문서)
- id — BIGSERIAL — 기본 키 — NOT NULL
- message_id — BIGINT — 외래 키 → chat_messages.id — NOT NULL
- source_type — source_type — NOT NULL
- chunk_id — BIGINT — 외래 키 → chunks.id
- title — TEXT — NOT NULL
- url — TEXT
- snippet — TEXT
- score — FLOAT
- rank — INT
- created_at — TIMESTAMPTZ — NOT NULL
simulations (자산 시뮬레이션)
- id — BIGSERIAL — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id
- assets — JSONB — NOT NULL
- riders — JSONB — NOT NULL
- report — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
users (유저)
- id — BIGSERIAL — 기본 키 — NOT NULL
- email — TEXT
- created_at — TIMESTAMPTZ — NOT NULL