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