17 lines
932 B
Python
17 lines
932 B
Python
from sqlalchemy import Column, Integer, String, DateTime, Float, Date, Table, ForeignKey
|
|
from sqlalchemy.orm import relationship
|
|
from database import Base
|
|
|
|
class_teacher=Table("class_teacher",Base.metadata,
|
|
Column("cid",Integer,ForeignKey("student_class.cid"),primary_key=True),
|
|
Column("teacher_id",Integer,ForeignKey("teacher.teacher_id"),primary_key=True))
|
|
|
|
class Teacher(Base):
|
|
__tablename__="teacher"
|
|
teacher_id=Column(Integer,primary_key=True,autoincrement=True,comment="老师id")
|
|
teacher_name=Column(String(50),nullable=False)
|
|
gender=Column(String(5),comment="性别")
|
|
phone=Column(String(20),comment="联系电话")
|
|
is_headteacher=Column(Integer,default=0,comment="数据状态 1-班主任 0-教师")
|
|
flag=Column(Integer,default=1,comment="数据状态 1-正常 0-删除")
|
|
classes=relationship("Class",secondary=class_teacher,back_populates="teachers") |