111 lines
9.3 KiB
Markdown
111 lines
9.3 KiB
Markdown
<!--
|
||
* @Author: buji 1493005357@qq.com
|
||
* @Date: 2025-11-22 20:59:48
|
||
* @LastEditors: buji 1493005357@qq.com
|
||
* @LastEditTime: 2025-11-29 18:44:48
|
||
* @FilePath: \flower-rain-2\docs\石亚玲\syl-11-22-add_jh_tables_analyse.md
|
||
* @Description: 这是默认设置,请设置`customMade`, 打开koroFileHeader查看配置 进行设置: https://github.com/OBKoro1/koro1FileHeader/wiki/%E9%85%8D%E7%BD%AE
|
||
-->
|
||
## jinhua
|
||
## 用户表(tb_user)
|
||
|字段名(Field) |字段类型(Type) |Null |Key |Defult |Extra |
|
||
|:----------------------:|:----------------:|:------|:-------:|:--------:|:-------------:|
|
||
|user_id |BIGINT |no |PRI | |管理所有用户登录|
|
||
|username |varchar(20) |no | | |账号 |
|
||
|password |varchar(100) |no | | |加密后的密码 |
|
||
|role_type |tinyINT |no | | |1学生/2企业 |
|
||
|status |tinyINT | | | |账号状态(0-未激活/1-正常/2-冻结/3-注销) |
|
||
|create_time |DATETIME |no | | |注册时间 |
|
||
|update_time |DATETIME |no | | |信息更新时间 |
|
||
|last_login_time |DATETIME |yes | | |最后登录时间 |
|
||
|
||
**用角色区分求职用户和企业用户**
|
||
|
||
## 求职者表(tb_job_seeker)
|
||
|字段名(Field) |字段类型(Type) |Null |Key |Defult |Extra |
|
||
|:-----------------------:|:---------------:|:-----:|:-------:|:--------:|:-------------:|
|
||
|seeker_id |bigINT |not |PRI | |求职者唯一id |
|
||
|user_id |bigINT |not |foreign | |关联**tb_user.user_id** |
|
||
|gender |tinyINT | | | |0-未知/1-男/2-女 |
|
||
|phone |varchar(20) | |unique | |唯一手机号 |
|
||
|email |varchar(100) | |unique | |唯一邮箱 |
|
||
|birth_date |DATE | | | |出生日期 |
|
||
|city_id |int | |foreign | |所在城市，(关联**tb_city**表) |
|
||
|education_id |int | |foreign | |最高学历(关联**tb_education**表) |
|
||
|work_years |tinyINT | | | |工作年限(0-应届/1-1年以内/2-2年以内……) |
|
||
|resume_id |bigINT | |foreign | |关联**t_resume**表 |
|
||
|
||
## 企业表(tb_company)
|
||
|字段名(Field) |字段类型(Type) |Null |Key |Defult |Extra |
|
||
|:-----------------------:|:---------------:|:-----:|:-------:|:--------:|:-------------:|
|
||
|company_id |bigINT |not |PRI | |企业唯一ID |
|
||
|user_id |bigINT |not |foreign | |关联**tb_user.user_id** |
|
||
|company_name |varchar(50) |not |unique | |企业名称 |
|
||
|industry_id |int | |foreign | |所属行业，关联**tb_industry**表 |
|
||
|scale_id |int | |foreign | | 企业规模(关联**tb_company_scale**) |
|
||
|city_id |int | |foreign | |所在城市，(关联**tb_city**表) |
|
||
|address |varchar(200) | | | |详细地址 |
|
||
|contact_name |varchar(30) |not | | |联系人姓名 |
|
||
|contact_phone |varchar(20) |not | | |联系人手机号 |
|
||
|contact_email |varchar(100) | | | |联系人邮箱 |
|
||
|license_img |varchar(255) | | | |营业执照图片URL(用于企业认证) |
|
||
|auth_status |tinyINT | | |0 |企业认证状态(0-为认证/1-已认证/2-认证失败) |
|
||
|
||
## 职位表(tb_job)
|
||
|字段名(Field) |字段类型(Type) |Null |Key |Defult |Extra |
|
||
|:-----------------------:|:---------------:|:-----:|:-------:|:--------:|:-------------:|
|
||
|job_id |bigINT | |PRI | |职位唯一ID |
|
||
|company_id |bigINT | |foreign | |所属企业(关联tb_company)|
|
||
|job_category_id |INT | |foreign | |职位分类(技术/运营，关联tb_job(category)) |
|
||
|job_name |varchar(100) | | | |职位名称 |
|
||
|city_id |int | |foreign | |所在城市，(关联tb_city表) |
|
||
|work_address |varchar(200) | | | |工作详细地址 |
|
||
|salary |varchar(100) | | | |月薪 |
|
||
|education_id |int | |foreign | |学历要求，(关联**tb_education**表) |
|
||
|work_years |tinyINT | | | |工作年限(0-应届/1-1年以内/2-2年以内……) |
|
||
|recruit_num |int | | | |招聘人数 |
|
||
|job_desc |text | | | |职位描述 |
|
||
|publish_time |DATETIME | | | | 发布时间 |
|
||
|status |tinyINT | | | |职位状态(0-草稿/1-已发布/2-已下架/3-过期) |
|
||
|(*)collect_count |int | | | |浏览次数 |
|
||
|update_time |DATETIME | | | |
|
||
|
||
## 简历表(tb_resume)
|
||
|字段名(Field) |字段类型(Type) |Null |Key |Defult |Extra |
|
||
|:-----------------------:|:---------------:|:-----:|:-------:|:--------:|:-------------:|
|
||
|resume_id |bigINT | |PRI | |简历唯一ID |
|
||
|seeker_id |bigINT | |foreign | |所属求职者，关联tb_job_seeker |
|
||
|resume_name |varchar(100) | | | |简历名称(如:java开发-张三-3年经验) |
|
||
|job_intention_id |int | |foreign | |求职意向(关联tb_job_category) |
|
||
|expect_salary |varchar(100) | | | |期望薪资(5000-8000)|
|
||
|expect_city |int | |foreign | |所在城市，(关联tb_city表) |
|
||
|education_bg |TEXT | | | |教育经历 |
|
||
|work_experience |TEXT | | | | |
|
||
|skills |varchar(255) | | | |技能(Java，MySQL) |
|
||
|
||
## 申请表(tb_delivery)
|
||
|字段名(Field) |字段类型(Type) |Null |Key |Defult |Extra |
|
||
|:-----------------------:|:---------------:|:-----:|:-------:|:--------:|:-------------:|
|
||
|delivery_id |bigINT | |PRI | |投递记录ID |
|
||
|seeker_id |bigINT | |foreign | |关联tb_job_seeker |
|
||
|job_id |bigINT | |foreign | |关联tb_job |
|
||
|company_id |bigINT | |foreign | |关联tb_company |
|
||
|resume_id |bigINT | |foreign | |关联tb_resume |
|
||
|delivery_time |DATETIME | |foreign | |投递时间
|
||
|status |tinyINT | |foreign | |投递状态(0-待查看/1-已查看/2-邀约面试/3-录用/4-拒绝/5-已撤回) |
|
||
|(*)feedback |TEXT | |foreign | |企业反馈 |
|
||
|update_time |DATETIME | |foreign | |状态更新时间 |
|
||
|
||
*将教育经历表单独拉出来，做数组*
|
||
## 教育经历表
|
||
|字段名(Field) |字段类型(Type) |Null |Key |Defult |Extra |
|
||
|:-----------------------:|:---------------:|:-----:|:-------:|:--------:|:-------------:|
|
||
|edu_id |bigINT |NO |PRI | |教育经历唯一ID |
|
||
|resume_id |bigINT |NO |foreign | |关联 |
|
||
|school_name |varchar(100) |NO | | |学校名称 |
|
||
|major_name |varchar(100) |NO | | |专业名称 |
|
||
|education_id |int |NO |foreign | | |
|
||
|start_date |DATETIME |NO |foreign | |入学 |
|
||
|end_date |DATETIME |YES | | | 毕业 |
|
||
|description |TEXT | | | |教育经历描述 |
|