I have to design a table where user has 10 fields and 6 are dropdown. Some are single selections and some multiple. Dropdown data is supposed to change very rarely.
For e.g., the user is presented with days of the week and can select any number of days. It is going to be a one to many table
UserDayPref(user_id, day). Now I have 3 choices:
- Create table Days and make day field in
UserDayPrefa foreign key to
- Make day field as string and save the name of the day.
- Map Name of the day to an integer and save the integer.
I am inclined to implement the 3rd option for this and all other dropdown fields. I am pretty sure data will edited rarely.
Is this the right way to do it? Or going with Foreign Keys is the right way?