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已删除')