I am working on a project with the following data structure :
A user need to be able to perform personal filtering on a given project, and this filtering needs to be saved (for each user/project pair). For example, he can choose to filter based on attribute1, attribute 2.
For storing such user settings, I did use this schema:
and I can have for example a setting for attribute1 filtering, and in my user_setting table store the corresponding value.
My problem is that the user needs to be able to perform a manual filtering on the objects (i.e. filtering them with checkbox). That would result in choosing objectIDs among all the object IDs.
My first thought was to store them in setting_value as comma separated values, but I read that I should not denormalize (note that there can be a lot of objects, and a lot of projects).
Is it a good approach or should I rethink my user setting storage approach?