17 lines
701 B
Python
17 lines
701 B
Python
from sqlalchemy import Column, Integer, String, Date
|
|
from sqlalchemy.orm import relationship
|
|
from database import Base
|
|
from model.teacher_class import teacher_class
|
|
from model.teacher import Teacher
|
|
from model.student import Student
|
|
# 导入中间关联表
|
|
|
|
# 班级信息表
|
|
class ClassInfo(Base):
|
|
__tablename__="classinfo"
|
|
id=Column(Integer,primary_key=True,autoincrement=True)
|
|
class_name=Column(String(50),nullable=False,unique=True)
|
|
start_time=Column(Date)
|
|
statu=Column(Integer,default=1) # 逻辑删除表字段 1代表存在
|
|
teachers=relationship(Teacher,secondary=teacher_class,back_populates="classinfo")
|
|
students= relationship(Student,back_populates="classinfo") |