Let's say that you have a table that stores data about car parts. These parts have all kinds of data tied to em but one thing in particular is model_id (that is tied to a table called "models"). Ok..so let's furthur say that one part can fit like 7 different models. When inserting the data you get "model_id" as an array of model_ids to insert into a parts row.
What way do you store this data. One way is to implode the array into a comma or colon delimited string and store it that way. This works great except for when it's time to either search parts on model_id or even to print out what models (by name not id) each part fits. So that's the question...What's the best way to store an array that you will need to index down the line?
