chat

Tables (4)

chat-room (Untitled3)

  • roomnum (Key) — Primary key — NOT NULL
  • userCount (Field)

message (Untitled2)

  • msgID (Key) — Primary key — NOT NULL
  • content (Field3)
  • roomnum (Key2) — Foreign key → chat-room.roomnum — NOT NULL
  • sendAt (Field2)
  • userID (Key3) — Foreign key → user.userID — NOT NULL
  • type (Field)

room-user (Untitled4)

  • userID (Key) — Foreign key → user.userID — NOT NULL
  • roomnum (Key2) — Foreign key → chat-room.roomnum — NOT NULL
  • joinedAt (Field)
  • lastReadAt (Field2)

user (Untitled)

  • userID (Key) — Primary key — NOT NULL
  • userName (Field)
  • userPW (Field2)