Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
 Posted - 2014-06-04 : 20:20:19
|
I have a task of developing a program that with have two very unique user roles. One usertype will be a recruiter and the other usertype will be the job seeker. A recruiter can be a job seeker too.So do I have one user table and add a field to define the usertype, or do I create a Seperate usertype for both and when a recruiter is both types link the two accounts,Any input would be appreciated.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-06-04 : 20:58:48
|
| I would create 3 tables, one for Person, another for JobSeeker, and a third for Recruiter, with person id as FK in the second and third tables |
 |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2014-06-04 : 21:29:48
|
Although a good approach, going to do two Seperate tables, and if someone is both, they have two different accounts. Linking the two just overcomplicates treating them as two different entities which in essence they are. Thanks for the input though, it was a good solution, but after thinking it through why complicate something for a rare scenario when there r two roles.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
|
|
|
|
|
|
|
|
Two different user tables or One