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)