29 lines
1.4 KiB
Python
29 lines
1.4 KiB
Python
#
|
|
# 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")
|
|
#
|