Debian Codegraph @

tests/expressions_window/models.py

raw
1 from django.db import models
2
3
4 class Classification(models.Model):
5 code = models.CharField(max_length=10)
6
7
8 class Employee(models.Model):
9 name = models.CharField(max_length=40, blank=False, null=False)
10 salary = models.PositiveIntegerField()
11 department = models.CharField(max_length=40, blank=False, null=False)
12 hire_date = models.DateField(blank=False, null=False)
13 age = models.IntegerField(blank=False, null=False)
14 classification = models.ForeignKey(
15 "Classification", on_delete=models.CASCADE, null=True
16 )
17 bonus = models.DecimalField(decimal_places=2, max_digits=15, null=True)
18
19
20 class PastEmployeeDepartment(models.Model):
21 employee = models.ForeignKey(
22 Employee, related_name="past_departments", on_delete=models.CASCADE
23 )
24 department = models.CharField(max_length=40, blank=False, null=False)
25
26
27 class Detail(models.Model):
28 value = models.JSONField()
29
30 class Meta:
31 required_db_features = {"supports_json_field"}