Desgining 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
17:12 UTC
Read the original article
Hit count: 164
sql
Hi,
Am working on a design where I can have flexible attributes for a user & am confused how to continue the design of the schema.
I made a table where I kept system needed information called
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 even profile will be flexible if my clients need to create a new attribute he/she won't need any customization to the code?
Regards,
© Stack Overflow or respective owner