| 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"} |