I am confused. many-to-many relationship where there is extra attributes in this intermediate table uncommon ? This sounds like a textbook case.
Jeff Watkins wrote: > Not to dampen your enthusiasm, but this is the response I received > from Oleg on the SQLObject mailing list when I asked a similar question: > > "This need seems for me so uncommon... You can implement it yourself, > though." > > Since we're left to implement it ourselves, I would suggest making an > explicit join object: > > Person -> Call -> PhoneNumber > > So a person has a list of calls each of which has a ForeignKey for > the PhoneNumber. > > I was hoping for a Join type that represented mappings, which seems > like a *really* common scenario. If it weren't why would Python have > mapping types? > > On 1 Nov, 2005, at 9:11 pm, pi wrote: > > > I would like to create a many-to-many relationship between 2 objects, > > but with a little twist. I would like to store a few fields for each > > row in the relation. > > -- > Jeff Watkins > http://metrocat.org/ > > "Advertising directed at children is inherently deceptive and > exploits children under eight years of age." > -- American Academy of Pediatrics
