25 lines
1002 B
Python
25 lines
1002 B
Python
# model/teachers.py
|
|
# 老师表：沿用原 teacher 模块模型，统一命名与关系定义
|
|
from sqlalchemy import Column, Integer, ForeignKey, String
|
|
from sqlalchemy.orm import relationship
|
|
|
|
from database import Base
|
|
|
|
|
|
class Teacher(Base):
|
|
__tablename__ = "teacher"
|
|
|
|
teacher_id = Column(Integer, primary_key=True, autoincrement=True)
|
|
class_id = Column(Integer, ForeignKey("c_lass.class_id"), nullable=False, comment="所带班级")
|
|
teacher_name = Column(String(50), nullable=False, comment="教师姓名")
|
|
job_name = Column(String(50), nullable=False, comment="职务：主讲/班主任/助教")
|
|
is_deleted = Column(Integer, default=0, nullable=False, comment="逻辑删除: 0正常 1删除")
|
|
|
|
classes = relationship("Classinfo", back_populates="teachers")
|
|
|
|
def __repr__(self):
|
|
return (
|
|
f"<Teacher(teacher_id={self.teacher_id}, class_id={self.class_id}, "
|
|
f"teacher_name='{self.teacher_name}', job_name='{self.job_name}')>"
|
|
)
|