17 lines
738 B
Python
17 lines
738 B
Python
# model/score.py
|
|
from sqlalchemy import Column, Integer, Float, ForeignKey, DateTime
|
|
from sqlalchemy.orm import relationship
|
|
from datetime import datetime
|
|
from database import Base
|
|
|
|
|
|
class Score(Base):
|
|
__tablename__ = "score"
|
|
id = Column(Integer, primary_key=True, autoincrement=True) # 主键
|
|
student_id = Column(Integer, ForeignKey("student.id"), nullable=False) #外键
|
|
exam_seq = Column(Integer, nullable=False)
|
|
score = Column(Float, nullable=False)
|
|
is_warning = Column(Integer, default=0) #低分预警 0正常 1不及格
|
|
is_deleted = Column(Integer, default=0) #是否被逻辑删除
|
|
create_time = Column(DateTime, default=datetime.now)
|
|
student = relationship("Student", back_populates="scores") |