I'm torn between two different schemas and would love some of your thoughts.
Essentially, we have a list of items, and each item can have a bunch of extra boolean attributes, currently about 15 however this is very likely to grow in the future probably up to 50 and perhaps more, it would probably change periodically with new columns being added.
We currently have implemented a separate table, where each row belongs to an "item" in the other table. Each row in this table represents an attribute and has an "attribute name", and "flagged" columns to say if the attribute was flagged. This means for every item created, approx 15 rows in this table are created.
The other option is to create extra columns on the first table of items and store the boolean attributes there, however this could result in quite a lot of columns.
What would be the best way forward?