MySQL Forums
Forum List  »  Newbie

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

Written By
DB Design - Users Table
June 10, 2009 01:35AM
June 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.