from sqlalchemy import Column, Integer, String, DateTime, Float, Date
from sqlalchemy.orm import relationship
from database import Base
from model.teacher import class_teacher


class Class(Base):
    __tablename__ = "student_class"
    cid = Column(Integer, primary_key=True)
    class_name=Column(String(20),nullable=False)
    start_time=Column(Date,nullable=False)
    headteacher=Column(String(20),nullable=False)
    flag=Column(Integer,nullable=False,default=1)
    teachers=relationship("Teacher",secondary=class_teacher,back_populates="classes")
    student = relationship("Student", back_populates="classes")