mysql - Proper database design for this task -

OK, so I'm going to be at least 2 tables, possibly three.

The data is going to be as follows:

First of all, a list of search terms. These search terms are not related to anything in the program (only involved in getting the output, there is no manipulation of this data), so I plan to store them in my table separately.

Then things get complicated. I have a list of words, and each word can be in many categories, for example, if you have "sad", then it can be under "anxiety" and "tragedy", like "happy" "happiness "And" perfection ".

Would it be better to set a table where I have three columns: It would be better to set a UID, a word and a category, or two tables: with both words, with a word , With a square, and set

The last line is generating a certain number of words in a certain category.

I am using MySQL and Python (MySQLdb) if it helps anyone.

Your 'search term' table (because this is in reference to any question) / P>

  words (w_id int, w_word varchar (50)) categories (c_id int, c_category) will be similar to WordCarechange (wc_wordid int, wc_catid int).   
 Add foreign key barriers to the table of words and categories from the id in the scope