/
models.py
42 lines (30 loc) · 1.24 KB
/
models.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
from django.db import models
# Create your models here.
class College(models.Model):
name = models.CharField(max_length=128)
location = models.CharField(max_length=64)
acronym = models.CharField(max_length=8,unique=True)
contact = models.EmailField()
def __str__(self):
return self.acronym
class Student(models.Model):
name = models.CharField(max_length=128,unique=True)
dob = models.DateField(null=True, blank=True)
email = models.EmailField()
db_folder = models.CharField(max_length=50)
dropped_out = models.BooleanField(default=False)
college = models.ForeignKey(College, on_delete=models.CASCADE,to_field='acronym') #
def __str__(self):
return self.name
class MockTest1(models.Model):
problem1 = models.IntegerField()
problem2 = models.IntegerField()
problem3 = models.IntegerField()
problem4 = models.IntegerField()
total = models.IntegerField()
student = models.OneToOneField(Student, on_delete=models.CASCADE,to_field='name')
def __str__(self):
return f"Student {self.student.name} marks"
class Teacher(models.Model):
name = models.CharField(max_length=40)
college = models.ForeignKey(College, on_delete=models.CASCADE,to_field='acronym')