09.02.2017, 08:45
Only store things in the User table that apply to every single user without exception. Storing a bunch of zeros or nulls is pointless. I will usually limit the amount of fields in a single table to a maximum of about 30 before it becomes unmanageable. Also make sure that you don't store things that can be derived or calculated, e.g. if you store birth date then don't store age.
I don't know what your setup is like so I can't give any concrete advice at the moment.
I don't know what your setup is like so I can't give any concrete advice at the moment.