U
U
Uber Noob2019-05-14 12:02:47
Database design
Uber Noob, 2019-05-14 12:02:47

What database architecture to choose for the project?

There is a site, the site has user registration via email + password. When authorizing through VK, it also immediately asks for an e-mail.
There is a mailing list, the user can subscribe to it, but he is not yet a registered user, he does not have a password ... There will be several mailing lists on different topics.
And there will be an analytics table that will store statistics on mailings and other user activity (whether they click on links in a letter, etc.).
And the affiliate program is also tied to users, i.e. each user has a partner account. The mailing subscriber automatically exits = partner (if it is one entity)
Questions:
1) to make a single table with users and mailing subscribers, or divide them into subscribers and registered users?
2) should a table with user quality analytics be made into a separate table? In general, you can also add 100 columns in the table with users: registration source, mailing open rate, link click-through rate, account login frequency, etc.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question