41 lines
1.8 KiB
Python
41 lines
1.8 KiB
Python
from database import DATETIME,Base,engine
|
|
from datetime import datetime
|
|
from sqlalchemy import Column,String,Date,Integer
|
|
|
|
|
|
|
|
class Teacher(Base):
|
|
__tablename__ = 'teacher_info'
|
|
id = Column(Integer,primary_key=True,autoincrement=True,comment='自增主键id')
|
|
teacher_id = Column(String(20),nullable=False,unique=True,comment='教师编号')
|
|
teacher_name = Column(String(50),nullable=False,comment='老师姓名')
|
|
gender = Column(Integer,nullable=False,comment='性别:0=女,1=男')
|
|
birthday = Column(Date,nullable=True,comment='出生年月')
|
|
native_region_code = Column(String(12),nullable=True,comment='籍贯地区编码')
|
|
email = Column(String(100),nullable=True,comment='邮箱')
|
|
phone = Column(String(11),nullable=False,comment='手机号')
|
|
graduation_school = Column(String(20),nullable=True,comment='毕业院校')
|
|
is_deleted = Column(Integer,nullable=False,default=0,comment='逻辑删除：0=未删除，1=已删除')
|
|
create_time = Column(DATETIME,nullable=False,default=datetime.now,comment='创建时间')
|
|
update_time = Column(DATETIME,default=datetime.now,onupdate=datetime.now,comment='更新时间')
|
|
|
|
|
|
|
|
class TeacherCourse(Base):
|
|
__tablename__ = 'teacher_course'
|
|
id = Column(Integer,primary_key=True,autoincrement=True,comment='记录ID')
|
|
teacher_id = Column(String(20),nullable=False,comment='教师编号')
|
|
course_id = Column(String(20),nullable=False,comment='任课科目编号')
|
|
is_deleted = Column(Integer,nullable=False,default=0,comment='逻辑删除：0=未删除，1=已删除')
|
|
create_time = Column(DATETIME,nullable=False,default=datetime.now,comment='创建时间')
|
|
update_time = Column(DATETIME,nullable=False,default=datetime.now,onupdate=datetime.now,comment='更新时间')
|
|
|
|
|
|
|
|
if __name__ == "__main__":
|
|
Base.metadata.create_all(engine)
|
|
print("数据表创建完成！")
|
|
|
|
|
|
|