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)
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)
