比赛与其玩家之间的数据库关系

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_＆lt; 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

我认为我一直在寻找的是Manytomany的关系。
doc： https：// https：//djangoproject.com/fr/4.0 /topics/db/xplass/many_to_many/