mongoERD

Tables (4)

study_chats (study_chats)

  • _id — ObjectId — Primary key — NOT NULL
  • chattingRoomId — ObjectId — Foreign key → study_chats_rooms._id — NOT NULL
  • sender — number
  • receiver — number
  • content — string
  • createdAt — date

lightning_chats

  • _id — ObjectId — Primary key — NOT NULL
  • chattingRoomIdc — ObjectId — Foreign key → lightning_chats_rooms._id — NOT NULL
  • sender — number
  • receiver — number
  • content — string
  • createdAt — date

lightning_chats_rooms

  • _id — ObjectId — Primary key — NOT NULL
  • owner — number
  • applicant — number
  • roomId — uuid
  • createdAt — date
  • deletedAt — date
  • lightningBoardId — number

study_chats_rooms

  • _id — ObjectId — Primary key — NOT NULL
  • owner — number
  • applicant — number
  • roomId — uuid
  • createdAt — date
  • deletedAt — date
  • studyBoardId — number