[Fixed]-Need advice on relations between models\tables

by

1👍

✅

I’ll take a stab at this, i’m not sure how much of an improvement this is but its what started running through my head as i was reading your question..

I’m not sure of the differences or similarities of the team and user profiles are but you may want to make that into a single model and then have a type that defines if its a user or team. Then have a relationship to itself if you want to have a team with user profiles assigned to it. 

class Profile(models.Model):
    PROFILE_TYPES = (
        ('USER', 'User'),
        ('TEAM', 'Team'),
    )
    type = models.CharField(max_length=4, choices=PROFILE_TYPES)
    first_name = models.CharField(_('first name'), max_length=30, blank=True)
    last_name = models.CharField(_('last name'), max_length=30, blank=True)
    birth_date = models.DateField(_('birth date'), null=True, blank=True)
    user = models.ManyToManyField('Profile') #manytomany itself for teams that have profiles assigned to it
    name = models.CharField(_('company name'), max_length=30, blank=True)
    info = models.TextField(_('information'), max_length=500, blank=True)

Then just have a single sports model like you had and just relating back to the profile

class Sports(models.Model):
    KINDS_OF_SPORTS = (
        (1, _('football')),
        (2, _('volleyball')),
        (3, _('hockey')),
    )

    MASTERY_CHOICES = (
        (1, _('newby')),
        (2, _('amateur')),
        (3, _('semi-pro')),
        (4, _('pro'))
    )
    kind_of_sport = models.IntegerField(_('kind of sport'), null=True, blank=True, choices=KINDS_OF_SPORTS)
    mastery = models.IntegerField(_('mastery'), null=True, blank=True, choices=MASTERY_CHOICES)
    profile = models.ForeignKey(Profile, on_delete=models.CASCADE)
👤davidejones

Leave a comment