chat

Tables (4)

ChatMessage (Untitled)

  • id (Key) — Primary key — NOT NULL
  • sender (Field)
  • receiver (Field2)
  • content (Field3)
  • roomId (Field4)
  • timestamp (Field5)
  • read (Field6)
  • imageUrl (Field7)

ChatReadStatus (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • roomId (Field)
  • messageId (Field2)
  • userId (Field3)

ChatRoomMember (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • userId (Field)
  • chatRoom (Key2) — Foreign key → chatRoom.id — NOT NULL

chatRoom (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • group (Field2)
  • chatRoom (Field3)