I have a Users table which stores various characteristics about the users. For example basic stuff like age, sex, location, etc. These ofcourse hold single values which are easy to store. But I also have attributes that need to hold multiple choice values. It doesn’t seem like good database design to store multiple comma separated values into one field. But it also seems counterintuitive to store the atributes with multiple choice values in a separate table. So what would be the correct solution?
i guess this depends on who is doing the intuiting
this is actually the correct solution
Thanks! Guess I have to re-arrange some stuff hehe