I am developing a chat application in asp.net using SignalR.
Client requirements are:
Admin can create different chat rooms e.g. (News Room, Sports Room, Android Room etc)
Registered users can then join different chat rooms (one at a time) to chat with other online users on selected chat room.
Each user's chat history should be stored.
These are major requirements of my client. I have developed the following database schema at the moment for managing users and chat history of users.
Table 1: User
Fields: user_id, username, firstname, lastname, email, phone
Table 2: chathistory
Fields: ch_id, user_id(FK), sendby, sendto, message, time, date
But now I am confused in creating database schema for multiple chat rooms. How should I create or manage database schema for chat rooms. Please help me out to get it done as per my client's requirements.