chat

Tables (4)

chat_member (Untitled3)

  • room_id (Key) — Foreign key → chat_room.room_id — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • joined_at (Field)
  • last_read_at (Field2)

chat_message (Untitled4)

  • message_id (Key) — Primary key — NOT NULL
  • room_id (Key3) — Foreign key → chat_member.room_id — NOT NULL
  • user_id (Key22) — Foreign key → chat_member.user_id — NOT NULL
  • content (Field)
  • sent_at (Field2)
  • is_deleted (Field3)

chat_room (Untitled2)

  • room_id (Key) — Primary key — NOT NULL
  • is_group (Field)
  • title (Field2)
  • created_at (Field3)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL