KenBrace 9 Posted February 20, 2015 I'm having a hard time figuring out the logic for creating a private messaging system that allows for more than 2 participants. What kind of database setup could I use to do this? I don't want to have a table with field for "user1", "user2", "user3", etc. because it strikes me as terribly inefficient and just messed up. How can I store the users of a conversation? Maybe have a table for conversations, messages, and participants? Then all the users inside the participants table that are filed under the specific conversation ID are allowed to access? Would there be a way to do it with only two tables? What do you think is the most efficient way to accomplish this task? Quote Go to top Share this post Link to post Share on other sites
Nathan 287 Posted February 20, 2015 I would do something like this: convo id convo createDate convoOwnerID messages id convoID message createDate messageOwnerID convoParticipants id userID convoID hasRead 1 KenBrace reacted to this Quote Go to top Share this post Link to post Share on other sites
KenBrace 9 Posted February 22, 2015 I would do something like this: convo id convo create_date convo_owner_id messages id convo_id message create_date message_owner_id convo_participants id user_id convo_id I think XenForo does something similar to this for their conversation system. Seems to work pretty good. Thanks for the suggestion! Quote Go to top Share this post Link to post Share on other sites
Nathan 287 Posted February 23, 2015 Ah never used or seen the database on Xenforo. Quote Go to top Share this post Link to post Share on other sites
Sohani30 1 Posted March 25 On 2/20/2015 at 9:31 PM, Nathan said: I would do something like this: convo id convo createDate convoOwnerID messages id convoID message createDate messageOwnerID convoParticipants id userID convoID hasRead Thanks for your valuable answer. It would be helpful to me. 1 Nathan reacted to this Quote Go to top Share this post Link to post Share on other sites
