summaryrefslogtreecommitdiff
path: root/tests/expressions_window/models.py
blob: d479d1aea61fcaf3922572eec26bf63c0486b32d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
from django.db import models


class Classification(models.Model):
    code = models.CharField(max_length=10)


class Employee(models.Model):
    name = models.CharField(max_length=40, blank=False, null=False)
    salary = models.PositiveIntegerField()
    department = models.CharField(max_length=40, blank=False, null=False)
    hire_date = models.DateField(blank=False, null=False)
    age = models.IntegerField(blank=False, null=False)
    classification = models.ForeignKey('Classification', on_delete=models.CASCADE, null=True)

    def __str__(self):
        return '{}, {}, {}, {}'.format(self.name, self.department, self.salary, self.hire_date)