GTHell
2 years ago
203
3
Tips

Multiple pivot table or one pivot table with multiple columns?

Posted 2 years 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.