페르소나 채팅 ERD

테이블 (9)

chat_events

  • id — bigint — 기본 키 — NOT NULL
  • room_id — uuid — 외래 키 → chat_rooms.id — NOT NULL
  • room_seq — bigint — NOT NULL
  • event_type — USER-DEFINED — NOT NULL
  • target_id — uuid — NOT NULL
  • payload — jsonb
  • created_at — timestamp — NOT NULL

chat_messages

  • id — uuid — 기본 키 — NOT NULL
  • room_id — uuid — 외래 키 → chat_rooms.id — NOT NULL
  • user_id — uuid — 외래 키 → users.id — NOT NULL
  • role — USER-DEFINED — NOT NULL
  • raw_text — text
  • metadata — jsonb
  • created_at — timestamp
  • deleted_at — timestamp
  • parts — jsonb
  • client_message_id — uuid

chat_room_counters

  • room_id — uuid — 외래 키 → chat_rooms.id — NOT NULL
  • last_seq — bigint — NOT NULL

chat_room_participants

  • id — bigint — 기본 키 — NOT NULL
  • room_id — uuid — 외래 키 → chat_rooms.id — NOT NULL
  • user_id — uuid — 외래 키 → users.id — NOT NULL
  • joined_at — timestamp
  • last_read_message_id — uuid
  • last_read_at — timestamp
  • unread_count — bigint — NOT NULL
  • session_start_message_id — uuid
  • is_active — bool

chat_rooms

  • id — uuid — 기본 키 — NOT NULL
  • owner_id — uuid — 외래 키 → users.id — NOT NULL
  • name — text
  • created_at — timestamp
  • message_count — integer — NOT NULL
  • updated_at — timestamp
  • last_memorized_message_count — integer
  • type — USER-DEFINED — NOT NULL
  • last_message — text
  • last_message_at — timestamp
  • deleted_at — timestamp
  • last_message_id — uuid

user_persona_memories

  • id — bigint — 기본 키 — NOT NULL
  • user_persona_id — bigint — 외래 키 → user_personas.id — NOT NULL
  • memory_content — text — NOT NULL
  • importance — integer
  • created_at — timestamp
  • happened_at — timestamp
  • tags — ARRAY
  • embedding — USER-DEFINED
  • deleted_at — timestamp

user_persona_states

  • id — bigint — 기본 키 — NOT NULL
  • user_persona_id — bigint — 외래 키 → user_personas.id — NOT NULL
  • summary — text
  • updated_at — timestamp

user_personas

  • id — bigint — 기본 키 — NOT NULL
  • persona_id — uuid — 외래 키 → users.id — NOT NULL
  • user_id — uuid — 외래 키 → users.id — NOT NULL
  • intimacy — integer — NOT NULL
  • energy — integer — NOT NULL
  • created_at — timestamp — NOT NULL

users (Untitled)

  • id — uuid — 기본 키 — NOT NULL
  • Field