22 lines
847 B
Python
22 lines
847 B
Python
from sqlalchemy import Column, Integer, String, Boolean, Date
|
|
from sqlalchemy.orm import relationship
|
|
|
|
from database import Base
|
|
|
|
|
|
class Teacher(Base):
|
|
__tablename__ = 'teacher'
|
|
t_id = Column(Integer, primary_key=True, autoincrement=True) #老师id
|
|
t_name = Column(String(50), nullable=False) #老师姓名
|
|
t_gender = Column(String(50), nullable=False) #性别
|
|
t_phone = Column(String(50), nullable=False) #手机号
|
|
t_subject = Column(String(50), nullable=False) #教授科目
|
|
t_created=Column(Date,nullable=False) #入职时间
|
|
t_delete = Column(Boolean, default=False) #逻辑判断
|
|
|
|
|
|
#关联表
|
|
classes=relationship('Classes',secondary='teacher_classes',back_populates='teachers')
|
|
|
|
def __repr__(self):
|
|
return f"<Teacher(t_id={self.t_id}, name='{self.t_name}', subject='{self.t_subject}')>" |