MySQL Forums :: Newbie :: DB Design - Users Table


Advanced Search

DB Design - Users Table
Posted by: iceangel89 LLL ()
Date: June 10, 2009 01:35AM

this maybe a common scenario. there are various types of users with different data stored abt them (different columns) so do i leave it that way? i think combining them will cause NULLs right for the columns that dont apply?

but in the application how shld i implement login?
1. Different Forms
2. Same Forms with a dropdown for users to specify the type of login
3. Same form but in application i "try" to login with 1 table followed by the other? (eg. try login 'Parents', 'Teachers', 'Admins' tables 1 by 1?)

Options: ReplyQuote


Subject Written By Posted
DB Design - Users Table iceangel89 LLL 06/10/2009 01:35AM
Re: DB Design - Users Table Rick James 06/11/2009 08:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.