网站搭建-django-学习成绩管理-02-数据库创建

from django.db import models


class Constants(models.Model):
    class_name = models.CharField(blank=True, null=True, max_length=10, verbose_name='班级')
    student_name = models.CharField(blank=True, null=True, max_length=10, verbose_name='学生姓名')
    exam_info = models.CharField(blank=True, null=True, max_length=20, verbose_name='模拟考信息')
    course_name = models.CharField(blank=True, null=True, max_length=20, verbose_name='科目')

    class Meta:
        db_table = 'grades_constants'
        verbose_name = "常数项"
        verbose_name_plural = verbose_name


class StudentGrades(models.Model):
    class_name = models.CharField(blank=True, null=True, max_length=10, verbose_name='班级')
    student_name = models.CharField(null=False, default='', max_length=10, verbose_name='学生姓名')
    exam_info = models.CharField(blank=True, null=True, max_length=20, verbose_name='模拟考信息')
    course_name = models.CharField(blank=True, null=True, max_length=20, verbose_name='科目')
    grades = models.FloatField(blank=False, null=False, default=0.0, verbose_name="学习成绩")

    class Meta:
        unique_together = ('class_name', 'student_name', 'exam_info', 'course_name')
        db_table = 'grades_record'
        verbose_name = "学习成绩记录"
        verbose_name_plural = verbose_name