Hey
Here's a good NxNxN problem and was wondering if there's some common solution. I'm guessing that NogDog, Weedpacket, or Brad will have the best suggestions ha
Let's just say an unlimited number of users can have an unlimited number of custom fields designated by an unlimited possible number of networks.
So John Doe can be in New York and New Jersey networks. New York asks for Age and Gender, New Jersey asks for Age and favorite car.
We have one solution where each additional custom value is added as a column to the users table (4096 column limit, but we doubt we'll hit that limit). Then we have a linking table designating which networks get which columns.
Another solution uses many linking tables so that each row is a custom field (age, gender, car) that links to which network it should be asked from. So this large table would contain all values of all custom fields.
The third solution takes that idea, but breaks the large table into different tables depending on data type. So there would be custom_int_fields, custom_text_fields, etc. so we can specify datatypes unlike the second solution.
If you can understand what I wrote I feel like you've already passed the first hurdle 🙂 Is there some fourth solution that is widely used and not just brainstormed?
