I have a User model that contains all of the users' account information, but now I'd like to give each user their own set of preferences. Using a database, what's the "best" solution to this?
I was thinking of setting up a Preference model with something along these lines:
id, user_id, preference_value_1, preference_value_2, etc.
And then for the relationship, doing something like:
Is this the right way to go about doing this, or is there a better way?