11 months ago

Split users and profiles into 2 different tables

Posted 11 months ago by packy

Is it better to always split users and profiles into 2 different tables? I always wonder this since some user information doesn't ever pertain to "admins" in my applications. For instance in one app a user with a role of "general" should have an: avatar, birthdate, motto, address and mood. For users with a role of "admin", non of this matters or will ever apply to them. So do you make 2 tables or just one and the admin users will just have some fields with NULL?

Please sign in or create an account to participate in this conversation.