simple-chat

Tables (4)

ChatRoom (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • participants (Field2)
  • messages (Field3)

ChatRoomParticipant (Untitled4)

  • chatRoomID (Key2) — Foreign key → ChatRoom.id — NOT NULL
  • sub (ID) — Foreign key → user.id — NOT NULL
  • chatRoom (Field)
  • user (Field3)

Message (Untitled3)

  • AuthorID (ID) — Foreign key → user.id — NOT NULL
  • chatRoomID (Key) — Foreign key → ChatRoom.id — NOT NULL
  • text (Field)
  • author (Field2)
  • chatRoom (Field4)

user (Untitled)

  • id (ID) — Primary key — NOT NULL
  • username (String)
  • email (Field)
  • sub (Field2)