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/V20231204004_plan_person.sql | 15 +++++---------- 1 files changed, 5 insertions(+), 10 deletions(-) diff --git a/assess-admin/src/main/resources/db/migration/V20231204004_plan_person.sql b/assess-admin/src/main/resources/db/migration/V20231204004_plan_person.sql index 34ec067..4d3259d 100644 --- a/assess-admin/src/main/resources/db/migration/V20231204004_plan_person.sql +++ b/assess-admin/src/main/resources/db/migration/V20231204004_plan_person.sql @@ -2,19 +2,14 @@ -- ---------------------------- -- 评价项目组成员表 -- ---------------------------- -drop table if exists `smart_assess`.`ass_plan_person`; CREATE TABLE `smart_assess`.`ass_plan_person` ( `id` bigint NOT NULL AUTO_INCREMENT, `person_id` bigint NOT NULL COMMENT '成员id', -`certificate_number` varchar(30) NOT NULL COMMENT '资格证书编号', -`ability` varchar(10) NOT NULL COMMENT '能力', -`business_ability_id` bigint NULL COMMENT '能力id(字典id)', -`identification_number` varchar(10) NOT NULL COMMENT '识别码', -`job_type` tinyint(2) NOT NULL DEFAULT 1 COMMENT '工作类型:1普通人员,2组长', -`later_promise` tinyint(1) NOT NULL COMMENT '承诺后期前往现场勘验(0否，1是)', -`professional_ability` varchar(50) NOT NULL COMMENT '专业能力', -`work` varchar(50) NOT NULL COMMENT '承担工作', -`scene_statue` tinyint(2) NOT NULL DEFAULT 1 COMMENT '场景状态1 2', +`job_type` tinyint NOT NULL DEFAULT 1 COMMENT '工作类型:1普通人员,2组长', +`play_role` tinyint NOT NULL DEFAULT 2 COMMENT '项目担任角色:1项目负责人,2项目组成员,3过程控制负责人,4机构评价负责人,5技术负责人，默认2', +`later_promise` tinyint(1) NOT NULL DEFAULT 0 COMMENT '承诺后期前往现场勘验(0否，1是)', +`informed` tinyint NULL DEFAULT 0 COMMENT '是否已告知(0否，1是，默认0)', +`work` varchar(50) NULL COMMENT '承担工作', `reason` varchar(30) NULL COMMENT '未到现场勘验原因(30字)', `sort` int NULL DEFAULT 0 COMMENT '排序', `project_id` bigint NOT NULL COMMENT '项目id', -- Gitblit v1.9.2