This sounds like a use case for a many good many relationship with bridge table
j
jbergius
09/19/2021, 5:56 AM
I’m not so experience working with databases. So I’m not really sure what you mean. Do you have any good explanation?! Eager to learn! 🔥
j
jon.m
09/19/2021, 4:01 PM
Well a many to many relationship is created using an intermediate table of data.
So you can have a subscription related to multiple prices, and a price related to multiple subscriptions.
jon.m
09/19/2021, 4:02 PM
And that sounds like what you need. I would google many to many relationship.
j
jbergius
09/19/2021, 4:02 PM
Yeah I’m familiar with many to many relationships. It was the bridge table I got stuck on.