This is more of a design question, on the best way to do this.
I am trying to build an "inventorying" application into my project. I need to allow people to add an unlimited amount of sub-data.
Right now I'm unable to determine the best way to be able to store data as searchable (so I think blob is out). I dynamically store what they call
Box Row Section
User 1 - Box 1
User 2 - Box 1 Row 3
User 3 - Box 1 Row 3 Section 4
User 4 - Box 1 Row 3 Section 4 Cell 7
User 5 - Warehouse 42 Isle 4 Shelf 4 Position 13
- inventory (TABLE)
- inventorylabels (TABLE)
- inventorylocation (TABLE)
I would setup the table like this:
| id | user_id | param | sequence |
Put the order of the parameters in sequence (so just count 1,2,3,etc.) Then do a recursive query for each param.