Level 23
definitely separate.. you could consider a polymorphic type where you have an extra field but KISS.. just have a separate tables one for watchlist, one for transactions.
1 like
Jun 20, 2018
3
Level 3
Multiple pivot table or one pivot table with multiple columns?
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?
Level 3
@shez1983 I just made one table with all the field as true or false. How do you come up with naming those pivot table?
Level 23
naming depends on what relationship it is you are trying to link two tables.. ie subscribers as opposed to product_users.. so anyone can see whats happening.. because in certain cases you might have product_users again for another relationship
Please or to participate in this conversation.