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
- username (nickname)
- password
- imageUrl (Field)
- imageFilename (Field2)