packy

Split users and profiles into 2 different tables

Posted 3 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.

Reply to

Use Markdown with GitHub-flavored code blocks.