[PonyORM-list] Automatic intermediate tables for all optional relationships

Erik Quaeghebeur ponyorm at equaeghe.nospammail.net
Tue Feb 23 09:45:34 UTC 2016


Hi list,


As I understand it, PonyORM uses an intermediate table for Set-Set (Many-to-Many) relationships and nullable attributes for Optional-Set and Optional-Optional relationships.

Is this correct?

If yes, as a feature request, would it be possible to implement an option that also uses an intermediate table for Optional-Set and Optional-Optional relationships? This would allow satisfying normalization requirements (i.e., avoiding nullable attributes).

Currently, this can be ‘faked’ using the Set-Set relationship, but then uniqueness of relationships (Optional sides) will not be enforced.


Best regards,

Erik


More information about the ponyorm-list mailing list