상속자들

테이블 (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