From 983bdb5b89932b38d08a11ad1eed6ea89d1597e1 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期一, 29 一月 2024 10:07:31 +0800
Subject: [PATCH] 更新

---
 assess-admin/src/main/resources/db/migration/V20231127002_expert_info.sql |   44 +++++++++++++++++++++++---------------------
 1 files changed, 23 insertions(+), 21 deletions(-)

diff --git a/assess-admin/src/main/resources/db/migration/V20231127002_expert_info.sql b/assess-admin/src/main/resources/db/migration/V20231127002_expert_info.sql
index 517d21f..816f731 100644
--- a/assess-admin/src/main/resources/db/migration/V20231127002_expert_info.sql
+++ b/assess-admin/src/main/resources/db/migration/V20231127002_expert_info.sql
@@ -2,44 +2,46 @@
 -- ----------------------------
 -- 系统专家分类表
 -- ----------------------------
-drop table if exists `smart_assess`.`sys_expert_info`;
 CREATE TABLE `smart_assess`.`sys_expert_info`  (
-`expert_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
+`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
 `name` varchar(20) NOT NULL COMMENT '专家名称',
 `sex` tinyint NULL DEFAULT 2 COMMENT '性别(0男,1女,2未知,默认2)',
 `big_classify` bigint NULL COMMENT '类别id',
 `small_classify` bigint NULL COMMENT '类别id',
 `birthday` datetime NULL COMMENT '出生日期',
-`phone` varchar(11) NULL COMMENT '手机号',
+`phone` varchar(12) NULL COMMENT '手机号',
 `title` varchar(20) NULL COMMENT '职称',
 `electronic_photo` varchar(100) NULL COMMENT '电子照片',
 `id_card` varchar(18) NULL COMMENT '身份证号码',
-`duty_status` tinyint NULL COMMENT '在职状态',
-`company_name` varchar(20) NULL COMMENT '公司名称',
-`company_address` varchar(50) NULL COMMENT '公司地址',
+`duty_status` tinyint NULL COMMENT '在岗情况(0在岗,1退休)',
+`company_name` varchar(50) NULL COMMENT '单位名称',
+`company_address` varchar(60) NULL COMMENT '单位地址',
 `dept_name` varchar(20) NULL COMMENT '部门名称',
 `job` varchar(10) NULL COMMENT '职务',
-`company_telephone` varchar(11) NULL COMMENT '公司电话',
-`fax_num` varchar(11) NULL COMMENT '传真',
+`company_telephone` varchar(11) NULL COMMENT '单位电话',
+`fax_num` varchar(11) NULL COMMENT '传真号',
 `email` varchar(20) NULL COMMENT '邮箱',
-`graduation_school` varchar(20) NULL COMMENT '毕业学校',
-`degree` varchar(10) NULL COMMENT '学历',
+`graduation_school` varchar(30) NULL COMMENT '毕业学校',
+`degree` varchar(10) NULL COMMENT '最高学历',
 `speciality` varchar(20) NULL COMMENT '专业',
-`current_profession` varchar(20) NULL COMMENT '当前专业',
-`support_direction_safety` varchar(20) NULL COMMENT '支撑安全',
-`support_direction_prevention` varchar(20) NULL COMMENT '支撑预防',
-`support_direction_emergency` varchar(20) NULL COMMENT '支持应急',
-`resume_key` varchar(20) NULL COMMENT '简述',
-`paper_situation_key` varchar(20) NULL,
-`reward_key` varchar(20) NULL,
-`achievement_key` varchar(20) NULL,
-`personal_opinion_key` varchar(20) NULL,
-`recommend_unit_opinion_key` varchar(20) NULL,
+`current_profession` varchar(100) NULL COMMENT '现在从事专业或方向',
+`support_direction_safety` varchar(40) NULL COMMENT '支撑方向安全生产',
+`support_direction_prevention` varchar(40) NULL COMMENT '支撑方向防灾救灾',
+`support_direction_emergency` varchar(40) NULL COMMENT '支撑方向应急救援',
+`resume_key` varchar(600) NULL COMMENT '简历',
+`paper_situation_key` varchar(600) NULL COMMENT '论文情况',
+`reward_key` varchar(600) NULL COMMENT '奖励',
+`achievement_key` varchar(600) NULL COMMENT '成绩成果',
+`personal_opinion_key` varchar(600) NULL COMMENT '专家个人意见',
+`recommend_unit_opinion_key` varchar(600) NULL COMMENT '推荐单位意见',
+`source` tinyint NULL COMMENT '来源(1问卷,2系统)',
+`version` int NULL DEFAULT 0 COMMENT '乐观锁',
+`state` tinyint(2) NULL DEFAULT 1 COMMENT '审批状态(0暂存,1审核中,2审批通过,3审批驳回,4已作废 默认1)',
 `del_flag` tinyint(255) NOT NULL DEFAULT 0 COMMENT '删除标志(0代表存在,1代表删除,默认0)',
 `create_by` varchar(20) NULL COMMENT '创建人',
 `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 `update_by` varchar(20) NULL COMMENT '修改人',
 `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
 `remark` varchar(100) NULL,
-PRIMARY KEY (`expert_id`)
+PRIMARY KEY (`id`)
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统专家信息表' ROW_FORMAT = DYNAMIC;
\ No newline at end of file

--
Gitblit v1.9.2