Hi, I trying to create a hockey database, based on Django. The heaviest part so long is to define the structure of my models. There I need some help. What I have so far..
class Team(models.Model): name = models.CharField(max_length=60) class Player(models.Model): surname = models.CharField(max_length=60) lastname = models.CharField(max_length=60) class Game(models.Model): date_time = models.DateTimeField() home_team = models.ForeignKey(Team,related_name='home_team') away_team = models.ForeignKey(Team,related_name='away_team') home_players = models.ManyToManyField(Player,blank=True) away_players = models.ManyToManyField(Player,blank=True) class GameGoal(models.Model): goal_scorer = models.ForeignKey(Player,blank=True,null=True) first_assist = models.ForeignKey(Player,blank=True,null=True) game = models.ForeignKey(Game) So now I have the following problems with these models. a) How can I limit the choice (in the admin page) of goal_scorer to Players, which are assigned to the Game? b) A GameGoal should be connected to the home_team or the away_team, how can I handle this? Add a foreignkey to Team and limit the choice to the both teams? c) Is there a better way, to define such a case? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---