Displaying 1 result from an estimated 1 matches for "sales_rep_info".
2006 May 29
9
design recommendations for authenticating users with lots of different attributes..?
...ers (such as administrators) won''t
need the extra info.
b) add as many common attributes (such as first_name, last_name, date
of birth) to the Users table and create another table for additional
information specific to the particular user type (ie add
primary_market, essay, etc to a "sales_rep_info" table)
c) ??
right now I''m using option B, but what I find confusing is if, for
example, I have a has_and_belongs_to_many relationship for sales reps,
such as primary_market (can be a combination of "automotive",
"electrical", "industrial", etc), do I...