Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2010

    Storing users with additional attributes

    Hey all!

    My database contains a table named "users" that stores a user id along with all sorts of information about the user. A second table defines to which user groups the user belongs.

    Now I have a user group for which I want to store additional information (to be specific - the database should store referees who have attributes like their fee, academic department etc.)

    My question is if it is a good practice to introduce a new table with one column for user ids so that I have a reference to my "users" table and be able to store all additional information for that user class in this table?

    Thank you for any help!!

  2. #2
    Join Date
    Jul 2009
    You would want to create a new table called something like Referee which contains the user ID (as a foreign key back to the user table) and any attributes that are specific to referees.

  3. #3
    Join Date
    Feb 2010
    That's the way I did it now - thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts