In my app, each user may have one of the 30 predefined occupations. Each occupation is a string of about 30 characters. Should I:
a. store this list of occupations in a mysql table and make occupation_id a foreign key in the User model? OR b. define this list as an array of constants in the User model? In option b, the array definition will be long and take up space in my user.rb file. Can I put it somewhere else? I am leaning toward option a because in the future I may want to allow each user to have more than one occupations. In that case, I will need to have another table to map the many-to-many relationship between users and occupations, right? In the future, more occupations may be added to the list. I may also try the autocomplete plugin. Thanks, Vincent. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
