title: MySQL multiple column relationships between 2 tables
body: <p>I have this problem in a table where there are 4 columns which include terms describing the product. I want to make this terms editable (and you can add more) in my app and there are 4 groups of them obviously. I created a table who has all these terms altogether but the product table will have to create 4 relationships with the ID of the terms table.</p>
  
  <p>Is this a good solution?</p>
  
  <p>The main reason I don't want to make 4 different tables for the terms is because there aren't many of them and as the app progresses we might have even more different term groups, thus adding many small tables cluttering the database.</p>
  
  <p>Any suggestion?</p>
  
  <p>Update #1: Here is my current schema <a href="http://i.imgur.com/q2a1ldk.png" rel="nofollow">http://i.imgur.com/q2a1ldk.png</a></p>