php - MySQL efficient: multiple tables or columns with nulls -


i developing mysql db user list, , trying determine efficient way design it.

my issue comes in there 3 types of users: "general", "normal", , "super". general , normal users differ in values of columns, schema store them identical. however, super users have @ least 4 columns of info needs stored.

in addition, each user needs unique user_id reference other parts of site.

so, can keep 3 users in same table, have lot of null values stored general , normal user rows.

or, can split users 2 tables: general/normal , super. rid of abundance of nulls, require lot more work keep track of user_ids , ensure unique, have handle in php instead of doing serial column in single table solution above.

which solution more efficient in terms of memory usage , performance?

or there another, better solution not seeing?

thanks!

why not build table; coloumns need super users? 2 tables 1 users , 1 super users's info


Comments

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -