myhouse-chat
Tables (5)
chat_attachments (Untitled2)
- attachment_id (Key) — Primary key — NOT NULL
- message_id (Key2) — Foreign key → chat_messages.message_id — NOT NULL
- file_id (Field)
- original_filename (Field2)
- content_type (Field3)
- size_bytes (Field4)
- sort_order (Field5)
- created_at (Field6)
chat_messages (Untitled)
- message_id (Key) — Primary key — NOT NULL
- room_id (Key2) — Foreign key → chat_rooms.room_id — NOT NULL
- sequence (nonNull)
- sender_type (nonnull)
- sender_id (Field2)
- client_message_id (Field5)
- message_type (Field6)
- content (Field)
- created_at (Field3)
chat_outbox (Untitled3)
- job_id (Key) — Primary key — NOT NULL
- aggregate_type (Field)
- aggregate_id (Field2)
- event_type (Field3)
- payload (Field4)
- created_at (Field5)
- published_at (Field6)
- retry_count (Field7)
chat_room_read_cursor (Untitled5)
- room_id (PK) — Foreign key → chat_rooms.room_id — NOT NULL
- participant_type (Field)
- participant_id (Field2)
- last_read_sequence (Field3)
- updated_at (Field4)
chat_rooms (Untitled4)
- room_id (Key) — Primary key — NOT NULL
- user_id (Field2)
- agent_id (Field3)
- property_id (Field4)
- latest_sequence (Field5)
- created_at (Field6)
- last_message_at (Field7)