slack

Tables (3)

Message (message)

  • id (메세지) (message_id) — Primary key — NOT NULL
  • id (사용자) (user_id) — Foreign key → User.id — NOT NULL
  • roomId (room_id)
  • sender
  • message_type
  • message
  • createdAt
  • userId (웹소켓용) (username)

Room (room)

  • id (room_id) — Primary key — NOT NULL
  • roomname
  • roomimage

User

  • id (user_id) — Primary key — NOT NULL
  • email
  • username (nickname)
  • password
  • imageUrl (Field)
  • imageFilename (Field2)