sDesigning a database with flexible user profile

Posted by Mughrabi on Stack Overflow See other posts from Stack Overflow or by Mughrabi
Published on 2010-05-30T17:10:44Z Indexed on 2010/05/30 21:02 UTC
Read the original article Hit count: 145

Filed under:

I am working on a design where I can have flexible attributes for users and I am confused how to continue the design of the schema.

I made a table where I kept system needed information:

Table name: users

  • id
  • username
  • password

Now, I wish to create a profile table and have one to one relation where all the other attributes in profile table such as email, first name, last name, etc. My question is: is there a way to add a third table in which profiles will be flexible? In other words, if my clients need to create a new attribute he/she won't need any customization to the code.

© Stack Overflow or respective owner

Related posts about sql