chatNodeJS

Tables (6)

Chat (Untitled5)

  • Id (chatId) — Primary key — NOT NULL
  • chat
  • createdAt (Field)
  • roomId — Foreign key → Room.Id — NOT NULL
  • userId — Foreign key → User.Id — NOT NULL

ChatRoomMember (Untitled3)

  • Id (chatRoomMemberId) — Primary key — NOT NULL
  • createdAt (Field)
  • userId — Foreign key → User.Id — NOT NULL
  • roomId — Foreign key → Room.Id — NOT NULL

Follow (Untitled4)

  • createdAt (Field)
  • followerId — Foreign key → User.Id — NOT NULL
  • followingId — Foreign key → User.Id — NOT NULL

Friendship (Untitled6)

  • status
  • createdAt
  • userAId — Foreign key → User.Id — NOT NULL
  • userBId — Foreign key → User.Id — NOT NULL

Room (Untitled2)

  • Id (roomId) — Primary key — NOT NULL
  • roomType
  • createdAt (Field2)

User (Untitled)

  • Id (userId) — Primary key — NOT NULL
  • email
  • nick (Field2)
  • password
  • createdAt