I'm designing a database for a review site.
There are products, and then for each product there can be multiple reviews.
I'm trying to add a subscription system, so that a user can subscribe to reviews and see the new ones when they login to the system.
This is an simple ER diagram with only the part of product and the review, I'm having doubts about how to do the subscription part.
How would you do it?
My thoughts are that first I have to save what the user subscribes to, something like this:
Would you do this in relation to the product or the reviewproduct? Also this is a many-to-many, so I would decompose in an associative entity.
Now my biggest doubt, I need to save the new reviews for the products that the user subscribed, how would you do this in the ER?
Thanks for the help, Br, Tiago