Posted in Database
I'm modeling game results in a Django app I'm working on. A team consists of one or more players, and players may be on multiple teams – a
ManyToManyField in Django. Then there are locations that maintain a list of players (not teams) who are authorized to play there, and players may be authorized for multiple locations – another
ManyToManyField. What I wanted to find was, given a location, a list of teams whose players are all authorized to play at that location.