I have a table of “users” and every user can subscribe to multiple topics.
What is the best way to store the user subscribed “topics” in a table?
Tell me if there is a better solution than this:
Insert a new row every time a user subscribe to a new topic. for example:
userID | topicID
1 | 3342
1 | 4342
2 | 1343
3| 532432
3| 343
3| 3434
3| 3443