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 (
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?