[sqlalchemy] Re: Consolidate multiple one-to-one into a list

2020-04-18 Thread Jens Troeger
Thank you, Jonathan. I’ve used SQLA’s association proxies before, I’ll take a look again. You bring up a good point, though: Ok, so this isn't a one-to-one relationship, but a many-to-many > relationship. > That’s something I’ve been debating with myself for a while before I posted here: the

[sqlalchemy] Re: Consolidate multiple one-to-one into a list

2020-04-18 Thread Jonathan Vanasco
On Friday, April 17, 2020 at 8:02:50 PM UTC-4, Jens Troeger wrote: > > > Indeed, Child does have multiple parents… > Ok, so this isn't a one-to-one relationship, but a many-to-many relationship. I would opt for a 3 table structure: Parent Parent_2_Child Child The