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)