How to correctly plan a database for storing users?

Question

Database design

Hello! I am making a website in Yii2. It is necessary to store users and information about them. On Codeigniter 3, I made a users, users_info table and I stored authorization data / everything else (avatars, detailed information) in them, respectively. Am I doing it right or is there a better way?

Answer 1

There is no single answer, in general you are doing the right thing, here you need to see the golden mean. If you feel that there are too many columns, divide, and also see that you are doing JOIN in users_info everywhere, then you should think about whether you need to store in 2.