gistfile1.py

class Match(models.Model):
    class Meta:
        verbose_name_plural = 'matches'
        db_table = 'match'

    period = models.ForeignKey(Period, null=False)
    date = models.DateField('Date played', null=False)
    pla = models.ForeignKey(Player, related_name='match_pla', verbose_name='Player A', null=False)
    plb = models.ForeignKey(Player, related_name='match_plb', verbose_name='Player B', null=False)
    sca = models.SmallIntegerField('Score for player A', null=False, db_index=True)
    scb = models.SmallIntegerField('Score for player B', null=False, db_index=True)

    rca = models.CharField(max_length=1, choices=MRACES, null=False, verbose_name='Race A', db_index=True)
    rcb = models.CharField(max_length=1, choices=MRACES, null=False, verbose_name='Race B', db_index=True)

    treated = models.BooleanField('Computed', default=False, null=False)
    event = models.CharField('Event text (deprecated)', max_length=200, default='', blank=True)
    eventobj = models.ForeignKey(Event, null=True, blank=True, verbose_name='Event')
    submitter = models.ForeignKey(User, null=True, blank=True, verbose_name='Submitter')

    game = models.CharField(
        'Game', max_length=10, default=WOL, blank=False, null=False, choices=GAMES, db_index=True
    )
    offline = models.BooleanField('Offline', default=False, null=False, db_index=True)

    rta = models.ForeignKey('Rating', related_name='rta', verbose_name='Rating A', null=True)
    rtb = models.ForeignKey('Rating', related_name='rtb', verbose_name='Rating B', null=True)