mysqldatabase-designschema-designsettings

Database user table design, for specific scenario


I know this question has been asked and answered many times, and I've spent a decent amount of time reading through the following questions:

The problem is that there seem to be a somewhat even distribution of supporters for a few classes of solutions:

So at the risk of asking a duplicate question, I'd like to describe my specific scenario, and hopefully get a more specific answer.

I'm leaning towards creating a second user_settings table and stick "non-essential" information such as email notification settings there, for the sake of keeping the main user table more readable, but is very curious to hear what expects have to say.


Solution

  • Seems that your dilemma is to vertically partition the user table or not. You may want to read this SO Q/A too.