How to store messages in the database?

N

naneri2014-12-25 13:52:37

MySQL

naneri, 2014-12-25 13:52:37

You need to create a database schema for a social network. I can't figure out how to organize messaging between two users.
At the moment I made a table - "coversations" and a table "messages",
but it turns out in "conversations" I don't know where to put the user id (because there are two id, not one).

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

V

Vitaly Kuznetsov, 2014-12-25
@vitaly44

The task is extremely voluminous and requires first working out IA, UX, UI and only then programming ... That's why such questions arise, take VKontakte as a basis and decompose the information structure, then user interaction and then interface features, the database structure will be created by itself .

I

Immortal_pony, 2014-12-25
@Immortal_pony

messages: from, to, text;
conversations is not needed.