#
# from sqlalchemy import Column, Integer, String, ForeignKey
# from sqlalchemy.orm import relationship
# from sqlalchemy.sql.sqltypes import DateTime
# from database import Base
#
#
# #学生表
# class Student(Base):
#     __tablename__ = "student"
#     id = Column(Integer, primary_key=True,autoincrement=True)  #学生编号
#     # class_id = Column(Integer,ForeignKey('student_class.id'))  #班级ID
#     advisor=relationship("Advisor",back_populates="students")
#     student_no = Column(Integer)  #学号
#     name = Column(String(10),nullable=False)  #姓名
#     native_places = Column(String(10),nullable=False)  #籍贯
#     school = Column(String(10),nullable=False)  #学校
#     major = Column(String(10),nullable=False)  #专业
#     enrollment_time = Column(DateTime(timezone=True),nullable=False)  #入学时间
#     graduation_time = Column(DateTime(timezone=True),nullable=False)  #毕业时间
#     education = Column(String(10),nullable=False)  #学历
#     advisor_id = Column(Integer,ForeignKey('advisor.id'),nullable=False)  #顾问编号
#     age = Column(String(10),nullable=False)  #年龄
#     gender = Column(String(10),nullable=False)  #性别
#     status = Column(String(10))  #状态(在读、进入就业、已就业)
#     flag = Column(Integer,nullable=False) #逻辑删除标记  0表示已经删除  1表示可以删除
#     scores = relationship("Score",back_populates="student")
#