In this hypothetical example should the foreign key constraint setup for the
UserId columns in the
ProductUserCommentAction table be referencing the Product/User tables as shown in the first diagram OR is it OK for those columns to reference the
ProductUserComment table as shown in the second diagram?
I like how it’s setup in the second diagram as it reduces the spider web in visualizations.
Are there any downsides to this second approach?