Пример #1
0
class Student(db.Model):
    """学生"""
    __tablename__ = "student"
    id = db.Column(db.Integer, primary_key=True)  #
    stu_id = db.Column(db.String(20), unique=True, nullable=False)
    stu_name = db.Column(db.String(32), nullable=False)
    stu_class = db.Column(db.String(20))
Пример #2
0
class GeographyScore(db.Model):
    """数学成绩表"""
    __tablename__ = "geographyscore"
    id = db.Column(db.Integer, primary_key=True)
    stu_id = db.Column(db.String(20),
                       db.ForeignKey("student.stu_id"),
                       nullable=False)
    exam_id = db.Column(db.Integer, db.ForeignKey("exam.id"), nullable=False)
    score = db.Column(db.Integer, default=0)
Пример #3
0
class BiologicalScore(db.Model):
    """生物成绩表"""
    __tablename__ = "biologicalscore"
    id = db.Column(db.Integer, primary_key=True)
    stu_id = db.Column(db.String(20),
                       db.ForeignKey("student.stu_id"),
                       nullable=False)
    exam_id = db.Column(db.Integer, db.ForeignKey("exam.id"), nullable=False)
    score = db.Column(db.Integer, default=0)
Пример #4
0
class Exam(db.Model):
    """考试"""
    __tablename__ = "exam"
    id = db.Column(db.Integer, primary_key=True)  #
    name = db.Column(db.String(60), unique=True, nullable=False)