I have a titles table, titles are movies or series. I want to suggest users similar titles so there is a one-to-many relation in the title_suggestions table (title_id, suggestion_id which refers to another title). The suggestions of a title may change at any time.
The user requests my application to suggest based on a title and now I want to store each user suggestion request in my database and I am confused what is the best and correct way to do it.
can anyone help me with this?
