17 lines
914 B
Python
17 lines
914 B
Python
|
from sqlalchemy import Column, Integer, String, Date, Float, Numeric, ForeignKey
|
||
|
|
from sqlalchemy import create_engine
|
||
|
|
from sqlalchemy.orm import relationship
|
||
|
|
SQ_URL = "mysql+pymysql://root:123456@localhost:3306/student_system"
|
||
|
|
engine = create_engine(SQ_URL,pool_size=5,echo=True)
|
||
|
|
from database import Base
|
||
|
|
class Work(Base):
|
||
|
|
__tablename__ = 'student_work'
|
||
|
|
# 包含字段：学生编号ID、学生姓名、学生班级、就业开放时间、offer下发时间、就业公司名称、就业薪资
|
||
|
|
employment_id = Column(Integer, autoincrement=True,primary_key=True)
|
||
|
|
sid = Column(Integer,ForeignKey("student.sid"), unique=True)
|
||
|
|
open_time = Column(Date, default="1970-01-01")
|
||
|
|
offer_time = Column(Date, default="1970-01-01")
|
||
|
|
company_name = Column(String(50))
|
||
|
|
salary = Column(Numeric(10,2))
|
||
|
|
flag = Column(Integer, default=1)
|
||
|
|
student = relationship("Student", back_populates="work")
|