Unanswered: Many to Many relationship: Is this correct?
I am new to this forum and also to SQL, DB design. I am stuck with a situation where I cannot define relationship between two tables. It goes something like this. Pls correct me whereever possible.
The first table 'Products' can have many 'Feature' and a 'Feature' can belong to many products (many to many). 'Feature' can be name-value pair or name-collection. I am storing the collection in the same column as value is stored and collection values are comma-separated values.
Now if a feature is assigned to a Product, one should be able to configure his own value for a product. For example, P1 and P2 are products and F1 is a collection type feature (V1, V2, V3). If i assign F1 to P1 and P2, then I should be able to configure its own value. V1 for P1 and V2 for P2.
How do I implement this kind of relationship?
Just as a work around i have created a new table P_F in which I have (Pid, Fid, Value), where 'Value' is each product's own feature value.