Fetching Data Between Models

[tech george]

I have a model Staff and LeaveReportStaff, I wanted to get leave_balance between Total_Leave_Days and leave_days. I already used Foreignkey for staff but I'm not sure if it is right to use Foreignkey again.

Please advise the best way forward.

class Staff(models.Model):
    Total_Leave_Days = models.PositiveIntegerField(default=0)
    course = models.ForeignKey(Course, on_delete=models.DO_NOTHING, null=True, blank=False)
    admin = models.OneToOneField(CustomUser, on_delete=models.CASCADE)


class LeaveReportStaff(models.Model):
    staff = models.ForeignKey(Staff, on_delete=models.CASCADE)
    start_date = models.DateField()
    end_date = models.DateField()
    leave_type = models.CharField(choices=LEAVE_TYPE, max_length=25, null=True, blank=False)

@property
def leave_days(self):
    return (self.end_date - self.start_date).days

@property
def leave_balance(self):
    return (self.Total_Leave_Days - self.leave_days)

[Derek]

You've already posted the same question:
https://groups.google.com/g/django-users/c/f7ZH2pcZp0s