I have a table that contains a list of people, and those people could well be siblings of each other – so I need a many to many with itself – is there a suggested way to do this? The only reliable way I can figure out is to store the relationship both ways.
It's the same as any other many-2-many, just write out the relation definition both ways.
There is currently no support for reciprocal relations, you if the relation has to be made both ways at the same time (if this is a child of a parent, the parent must be related to the child), you have to do that manually.
Donate
