Result Models.py File

from django.db import models

# Create your models here.



class Student(models.Model):
    GROUP = (
        ('Science','Science'),
        ('B.Studies', 'Business Studies'),
        ('Humatics', 'Arts and Humatics'),
        ('Generel','Generel'),
    )
    CLASS=(
        ('6','Six'),
        ('7','Seven'),
        ('8','Eight'),
        ('9','Nine'),
        ('10','Ten'),
        ('10X','Ex-Ten'),
    )
    GENDER=(
        ('Male','Male'),
        ('Female','Female'),
    )


    name=models.CharField('Student Name', max_length=200)
    class_name=models.CharField('Class Name', max_length=3, choices=CLASS)
    roll_number=models.IntegerField(default=0)
    group=models.CharField('Group Name', max_length=15, choices=GROUP)
    gender=models.CharField('Gender',max_length=5, choices=GENDER)

    def __str__(self):
        return self.name

class ExamName(models.Model):
    exam_name=models.CharField('Examination Name', max_length=100)

    def __str__(self):
        return self.exam_name



class MainSubject(models.Model):
    main_subject_name=models.CharField('Main Subject Name', max_length=100)

    def __str__(self):
        return self.main_subject_name


class SubjectPart(models.Model):
    subject_part=models.CharField('Subject Part',max_length=100)
    subject_full_marks=models.DecimalField('Full Marks',decimal_places=0, max_digits=4)

    def __str__(self):
        return self.subject_part


class SubjectType(models.Model):
    subject_type=models.CharField('Subject Type',max_length=20)
    subject_full_marks = models.DecimalField('Full Marks', decimal_places=0, max_digits=4)
    subject_pass_marks = models.DecimalField('Pass Marks', decimal_places=1, max_digits=4)

    def __str__(self):
        return self.subject_type



class Result(models.Model):
    examname = models.ForeignKey(ExamName, on_delete=models.CASCADE)
    student=models.ForeignKey(Student, on_delete=models.CASCADE)
    mainSubject = models.ForeignKey(MainSubject, on_delete=models.CASCADE)
    subjectPart = models.ForeignKey(SubjectPart, on_delete=models.CASCADE)
    subjectType = models.ForeignKey(SubjectType, on_delete=models.CASCADE)
    student_marks=models.DecimalField('Student Marks', decimal_places=2, max_digits=3)