Our client has a large bridal/wedding site. I say this so it will make sense the functionality we are requesting. Keep in mind, bridal/wedding site Members are temporary. The join the site to plan their wedding and once their wedding date is past they no longer use or visit the site. For purposes of the Favorites and Ratings modules we are using, the entries the Members “mark as Favorites” and the Ratings they apply to their Favorites will change over time. They add-n-remove favorites and update their Ratings/Comments on a particular “Wedding Location” (entry) over time as they interact with the Location.
Because we’re building a “members only” area to a large site, each Member will have their own Favorites listing page. Attached to each Favorite is the ability for the Member to Rate it and leave a comment for their own future reference and to compare against other Favorites they “add to their private area” of the site.
Also, using custom code, we allow a Member to email their friends and family and provide them with a “private link” to view that Member’s Favorites list.
Each friend/family can also leave a rating/comment on each Favorite.
We can Quarantine the Ratings and Comments, but this site will have tens of thousands of Members. And the Members and Friends/Family will add and remove Favorites and want to modify Ratings and Comments over time as I described above.
So, it would be most useful to us, if a specific “rating_id” and its associated relationships/stats could be removed rather than just quarantined. Quarantine has the effect on the “math” that we want, we just don’t want all these old Ratings/Comments hanging out in the table over time once the Member and her Friends/Family “deleted” it because they decided, for whatever reason, they were not going to hire that particular Location or Service for their wedding.
For us, Favorites and Ratings are related. For our client, they are one-in-the-same. And our client assumes, rightly so, that when a Member deletes a Favorite, all the Ratings/Comments are deleted as well. That would be our preference. But I know these two modules were not created with that in mind.
