21 lines
796 B
Python
21 lines
796 B
Python
#导入创造引擎、定义类模块、数据类型模块、连接符模块
|
|
from sqlalchemy import Column, Integer, String, Date, Float, ForeignKey
|
|
#导入基类
|
|
from sqlalchemy_fastapi_demo_1.database import Base
|
|
#定义就业基础模块
|
|
class EmploymentBase(Base):
|
|
__tablename__="employment_base"
|
|
stu_id=Column(Integer,ForeignKey("student.stu_id"),primary_key=True)
|
|
employment_open_time=Column(Date)
|
|
job_time=Column(Date)
|
|
company_name=Column(String(100))
|
|
salary=Column(Float)
|
|
is_deleted=Column(Integer,default=0)
|
|
#定义就业协议模块
|
|
class EmploymentOffer(Base):
|
|
__tablename__="employment_offer"
|
|
stu_id=Column(Integer,primary_key=True)
|
|
offer_id=Column(Integer,primary_key=True)
|
|
offer_time=Column(Date)
|
|
is_deleted=Column(Integer,default=0)
|