17 lines
731 B
Python
17 lines
731 B
Python
|
from sqlalchemy import Column, Integer, String, ForeignKey,Date,DateTime
|
||
|
|
from sqlalchemy.orm import relationship
|
||
|
|
from sqlalchemy.sql import func
|
||
|
|
from model import Base
|
||
|
|
from model.teacher_class import teacher_class
|
||
|
|
|
||
|
|
|
||
|
|
class Teacher(Base):
|
||
|
|
__tablename__="teacher"
|
||
|
|
id=Column(Integer,primary_key=True,autoincrement=True)
|
||
|
|
teacher_no=Column(String(50),unique=True,nullable=False)
|
||
|
|
name=Column(String(50),nullable=False)
|
||
|
|
phone=Column(String(50),nullable=False)
|
||
|
|
is_deleted=Column(Integer,default=0)
|
||
|
|
created_at=Column(DateTime,server_default=func.now())
|
||
|
|
updated_at=Column(DateTime,onupdate=func.now())
|
||
|
|
classinfo = relationship("ClassInfo",secondary=teacher_class, back_populates="teachers")
|