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