The screenshot shows an example of when many-to-many. The products may be different parameters, and the parameters can be different products.
Can't figure out how to solve the problem types, if the table options field value can be of different types? For example, I have a record where value TEXT(2000), respectively, this field will not fit in the current VARCHAR(255).
The only thing that came to mind to make a separate table with fields product_id (INT), value (TEXT). But something I do not particularly like that decision.
Has anyone encountered similar problems?