104 lines
3.0 KiB
Python
104 lines
3.0 KiB
Python
|
|
class Employment_model(Base):
|
|
__tablename__ = 'wl_employment'
|
|
|
|
e_id = Column(Integer
|
|
,primary_key=True
|
|
,autoincrement=True
|
|
,comment='序号'
|
|
)
|
|
|
|
stu_id = Column(Integer
|
|
,ForeignKey('wl_student.stu_id')
|
|
,nullable=False
|
|
,comment='学生编号'
|
|
)
|
|
|
|
email = Column(String(50)
|
|
,comment='邮箱'
|
|
)
|
|
|
|
Resume_opening_date = Column(DATE
|
|
,comment='简历开放时间'
|
|
)
|
|
|
|
offer_issuance_date = Column(DATE
|
|
,comment='offer下发时间'
|
|
)
|
|
|
|
c_id = Column(String(50)
|
|
,foreign_key='emp_company.c_id'
|
|
,comment='下发offer的企业编号'
|
|
)
|
|
|
|
offer_status = Column(String(10)
|
|
,nullable=False
|
|
,comment='收到offer的就业状态')
|
|
|
|
salary = Column(Integer
|
|
,comment='薪资'
|
|
)
|
|
|
|
create_time = Column(DATETIME
|
|
,default=datetime.now
|
|
,comment='数据创建时间'
|
|
)
|
|
|
|
update_time = Column(DATETIME
|
|
,default=datetime.now
|
|
,onupdate=datetime.now
|
|
,comment='数据更新时间'
|
|
)
|
|
|
|
delete_status = Column(Integer
|
|
,default=0
|
|
,comment='逻辑删除状态：0未删除，1已删除')
|
|
|
|
|
|
|
|
class Company_info(Base):
|
|
__tablename__ = 'emp_company'
|
|
|
|
id : Column(Integer
|
|
,primary_key=True
|
|
,autoincrement=True
|
|
,comment='序号'
|
|
)
|
|
c_id : Column(String
|
|
,unique=True
|
|
,comment='企业编号'
|
|
)
|
|
|
|
company_name : Column(String
|
|
,comment='企业名称'
|
|
)
|
|
|
|
Industry : Column(String
|
|
,comment='所属行业'
|
|
)
|
|
|
|
Personnel : Column(String
|
|
,comment='人员规模'
|
|
)
|
|
|
|
Main_business : Column(String
|
|
,comment='主营业务'
|
|
)
|
|
|
|
Registered_capital : Column(String
|
|
,comment='注册资金'
|
|
)
|
|
create_time = Column(DATETIME
|
|
,default=datetime.now
|
|
,comment='创建时间'
|
|
)
|
|
|
|
update_time = Column(DATETIME
|
|
,default=datetime.now
|
|
,onupdate=datetime.now
|
|
,comment='更新时间'
|
|
)
|
|
|
|
delete_status = Column(Integer
|
|
,default=0
|
|
,comment='删除状态：0未删除，1已删除') |