Answer the question
In order to leave comments, you need to log in
How to make the messaging system better?
I had a dilemma about how best to implement the message system.
There are two options.
The first one is three tables dialogList, dialogUsers and dialogMessages
dialogList:
id, type, name, owner
dialogUsers:
id, idDialog, status
dialogMessages:
id, idDialog, idUser, message
The second one is two tables dialogList and dialogMessages
dialogList:
id, type, name, owner , users(json object with list of users)
dialogMessages:
id, idDialog, idUser, message
question which system is better? which one to use and why?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question