doubledee Posted March 31, 2012 Share Posted March 31, 2012 My website allows Users to register and create a User Profile with tons of info about themselves, for example - First Name - Username - Email - City - State/Province - Zip Code - Country - Age - Interests - Occupation - Education - Company Type - Years in Business - Industry - # of Employees - Member Since and so on... Originally I was just going to put all of those fields in my "member" table, but now I am wondering if it wouldn't make more sense to break things out and create a many to many relationship like this... member -||------|< member_details ->0-------||- member_attribute What do you think?? Debbie Link to comment https://forums.phpfreaks.com/topic/260078-where-to-put-user-attributes/ Share on other sites More sharing options...
Proletarian Posted March 31, 2012 Share Posted March 31, 2012 What is a "many to many relationship"? Link to comment https://forums.phpfreaks.com/topic/260078-where-to-put-user-attributes/#findComment-1333057 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.