DoongTalk

Tables (3)

Room

  • roomID (Key) — String — Primary key — NOT NULL
  • userID (Key2) — String — Foreign key → User.userID — NOT NULL
  • messageID (Field) — String

User

  • userID (Key) — String — Primary key — NOT NULL
  • avatarUrl (Field) — String
  • email (Field2) — String
  • stateMessage (Field3) — String
  • username (Field4) — String
  • password (Field5) — String
  • userID (Key2) — String — Foreign key → User.userID — NOT NULL

message (Untitled)

  • mesaageID (Key) — String — Primary key — NOT NULL
  • userID (Key2) — String — Foreign key → User.userID — NOT NULL
  • roomID (Key3) — String — Foreign key → Room.roomID — NOT NULL
  • userID (Key22) — String — Foreign key → Room.userID — NOT NULL
  • createAt (Field) — Date