M
M
Maxim2019-01-06 18:46:16
MySQL
Maxim, 2019-01-06 18:46:16

How to properly design mysql DBMS?

I have one question about the correct construction of the DBMS, we are writing an application on June 2, the database should store information from different messengers, I think it’s right to make one messengers table where information such as the user ID and TD will be located and the second messengers_type where the names of the messenger and its incremental number, but my colleague insists that it is right to make your own table for each messenger, please tell me how to do it right

Answer the question

In order to leave comments, you need to log in

2 answer(s)
B
Boris Korobkov, 2019-01-07
@BorisKorobkov

Depends on the problem statement.
If it is supposed to process all user messages from different messengers, then it is more correct to store all messages in one table.
And if it is not expected, then why is your application needed?

A
Andrey, 2019-01-06
@VladimirAndreev

If there are no operations that require more than one messenger at a time, a colleague may be right ...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question