All individual subscriptions are 50% off this week only!

GTHell
1 year ago
54
3
Tips

Multiple pivot table or one pivot table with multiple columns?

Posted 1 year ago by GTHell

What is better when designing a many-to-many relation? For instance, I have a table users has relationship with projects table and the column that has many to many are like, add_to_watchlist, and transaction. I wonder if I should store this three in one pivot table or separate them all?

Please sign in or create an account to participate in this conversation.