How to store JSON data from APIs and be able to search efficiently
Keywords for indexing -- Either put it in a TEXT and apply a FULLTEXT index, or put the keywords one-per-row in another table (which is indexed).

To critique a schema, we need to see the main SELECTs that you will have.