페르소나 채팅 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