Need guidance in making mysql database model for basic chat web application
I am trying to build a basic chat application which will use PHP and MySQL. I have designed a model so far. please have a look.
Now I have some questions. let me show quickly what I want to achieve please check this image -
So in this image, there is a listing of all the conversations of the current user. I am also trying to build something similar. so the question is, is this(above database design) design will be effective or it could be better? if yes then how?
and please tell am i using correct relationships in my tables?
I am new at the SQL. any help will be appreciated. Thank you.
p.s. I have forgotten to add timestamps in the conversations and messages table. that I will add later so, I can sort my messages order_by timestamp.
Now I have some questions. let me show quickly what I want to achieve please check this image -
So in this image, there is a listing of all the conversations of the current user. I am also trying to build something similar. so the question is, is this(above database design) design will be effective or it could be better? if yes then how?
and please tell am i using correct relationships in my tables?
I am new at the SQL. any help will be appreciated. Thank you.
p.s. I have forgotten to add timestamps in the conversations and messages table. that I will add later so, I can sort my messages order_by timestamp.
Комментарии
Отправить комментарий