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