summaryrefslogtreecommitdiff
path: root/tests/expressions_window/models.py
blob: e1cc02323da1428a91d2f493dc61d2e8f8bed901 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
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)
    bonus = models.DecimalField(decimal_places=2, max_digits=15, null=True)


class Detail(models.Model):
    value = models.JSONField()

    class Meta:
        required_db_features = {'supports_json_field'}