一个比赛和它的球员之间的数据库关系

Question

我正在尝试设计一个数据库，将保存比赛和球员在3v3游戏。

到目前为止我的模型是这样的:

class Player(models.Model):
user = models.OneToOneField(User, on_delete=models.CASCADE, null=True)
player_tag = models.CharField(max_length=9, unique=True)
player_name = models.CharField(max_length=50)
trophy_count = models.IntegerField(default=0)
club = models.ForeignKey('Club', on_delete=models.SET_NULL, null=True)
total_club_war_trophy_count = models.IntegerField(default=0)

class Club(models.Model):
club_name = models.CharField(max_length=50)
club_tag = models.CharField(max_length=9, unique=True)

class Match(models.Model):
# Matches are 3v3
player_1 = models.ForeignKey(Player, on_delete=models.CASCADE)
player_2 = models.ForeignKey(Player, on_delete=models.CASCADE)
player_3 = models.ForeignKey(Player, on_delete=models.CASCADE)
player_4 = models.ForeignKey(Player, on_delete=models.CASCADE)
player_5 = models.ForeignKey(Player, on_delete=models.CASCADE)
player_6 = models.ForeignKey(Player, on_delete=models.CASCADE)
# Brawlball, Gem grab, Knockout ...
mode = models.CharField(max_length=20)
# Power match or normal match
battle_type = models.CharField(max_length=20)
trophies_won = models.IntegerField(default=0)
date = models.DateTimeField(auto_now_add=True)

然而"player_<int>";我觉得很痒，我不认为这是正确的做法。如果玩家数量在某个时刻发生变化，或者我如何发现玩家是否参与了比赛?我认为这充其量是一种笨拙的方法。

我怎样才能更好地处理这个问题?我在考虑一个玩家名单，但我不知道如何描述这种关系。

Answer 1

你可以这样使用Django的ManyToManyField:

class Match(models.Model):
# Matches are 3v3
players = models.ManyToManyField(Player, blank = True)
# Brawlball, Gem grab, Knockout ...
mode = models.CharField(max_length=20)
# Power match or normal match
battle_type = models.CharField(max_length=20)
trophies_won = models.IntegerField(default=0)
date = models.DateTimeField(auto_now_add=True)

然后你可以设置玩家为一场比赛。

match = Match.objects.get(pk = 1)
# players with ids (1,2,3) are in the match with id of 1.
match.players.set([1,2,3])

Answer 2

我想我在寻找的是一种多对多的关系。Doc: https://docs.djangoproject.com/fr/4.0/topics/db/examples/many_to_many/