Best way to model a relationship in gadget?
I have 2 fields on an Order model: StoneChoice1 and StoneChoice2, which each need to be linked to a Stone model.
The same stone record, could potentially be used for both choices (though generally they would differ), as well as on multiple Orders.
What would be the best form to model this relationship in gadget?
My intuitive feel would be two one-to-many relationships as one Stone can belong to many Orders.
I also cannot easily merge StoneChoice1 & 2 and have a many to many, as each Stone Choice has related fields like Stone finish. Although if anyone can suggest a methodolgy for this i'm open to it
The same stone record, could potentially be used for both choices (though generally they would differ), as well as on multiple Orders.
What would be the best form to model this relationship in gadget?
My intuitive feel would be two one-to-many relationships as one Stone can belong to many Orders.
I also cannot easily merge StoneChoice1 & 2 and have a many to many, as each Stone Choice has related fields like Stone finish. Although if anyone can suggest a methodolgy for this i'm open to it
