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.