# 数据库变更
# 许可证修改备注字段为 text类型
ALTER TABLE t_hazard_license
ALTER COLUMN remarks TYPE TEXT;

# 添加许可证表字段
ALTER TABLE t_hazard_license ADD COLUMN power_unit_signature TEXT;

# 安全条件确认明细表condition字段扩充
ALTER TABLE t_hazard_condition_confirmation_details
ALTER COLUMN condition TYPE varchar(2000);

# 危险作业计划监督检查
--  DROP TABLE `t_hazard_work_plan_check`;
CREATE TABLE "t_hazard_work_plan_check" (
"id" varchar(255) NOT NULL,
"plan_id" varchar(255) NULL,
"check_time" timestamp NULL,
"is_compliant" varchar(255) NULL,
"problem_type" varchar(255) NULL,
"check_description" text NULL,
"check_images" text NULL,
"check_signature" varchar(255) NULL,
"status" varchar(255) NULL DEFAULT '0',
"create_by" varchar(255) NULL,
"create_date" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
"update_by" varchar(255) NULL,
"update_date" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
"remarks" varchar(255) NULL,
"check_unit" varchar(255) NULL,
"basic_unit" varchar(255) NULL,
"check_status" varchar(255) NULL,
"check_signature_time" timestamp NULL,
"check_name" varchar(255) NULL,
"check_id" varchar(255) NULL,
"basic_id" varchar(255) NULL,
CONSTRAINT "PRIMARY_BFFDA859" PRIMARY KEY ("id")
);

COMMENT ON TABLE t_hazard_work_plan_check IS '危险作业计划监督检查';
COMMENT ON COLUMN t_hazard_work_plan_check.plan_id IS '危险作业计划id';
COMMENT ON COLUMN t_hazard_work_plan_check.check_time IS '检查时间';
COMMENT ON COLUMN t_hazard_work_plan_check.is_compliant IS '是否合规 0否 1是';
COMMENT ON COLUMN t_hazard_work_plan_check.problem_type IS '问题类别 字典id';
COMMENT ON COLUMN t_hazard_work_plan_check.check_description IS '问题描述';
COMMENT ON COLUMN t_hazard_work_plan_check.check_images IS '检查图片地址';
COMMENT ON COLUMN t_hazard_work_plan_check.check_signature IS '检查人签字';
COMMENT ON COLUMN t_hazard_work_plan_check.status IS '状态：0正常 1删除 2停用';
COMMENT ON COLUMN t_hazard_work_plan_check.create_by IS '创建者';
COMMENT ON COLUMN t_hazard_work_plan_check.create_date IS '创建时间';
COMMENT ON COLUMN t_hazard_work_plan_check.update_by IS '最后一次更新者';
COMMENT ON COLUMN t_hazard_work_plan_check.update_date IS '最后一次更新时间';
COMMENT ON COLUMN t_hazard_work_plan_check.remarks IS '备注';
COMMENT ON COLUMN t_hazard_work_plan_check.check_unit IS '检查单位';
COMMENT ON COLUMN t_hazard_work_plan_check.basic_unit IS '基层单位';
COMMENT ON COLUMN t_hazard_work_plan_check.check_id IS '检查单位id';
COMMENT ON COLUMN t_hazard_work_plan_check.basic_id IS '基层单位id';
COMMENT ON COLUMN t_hazard_work_plan_check.check_status IS '监督检查状态(1 暂存 2已完成)';
COMMENT ON COLUMN t_hazard_work_plan_check.check_signature_time IS '签字时间';
COMMENT ON COLUMN t_hazard_work_plan_check.check_name IS '检查人姓名';


INSERT INTO "t_sys_dict_type" ("dict_id", "dict_name", "dict_type", "is_sys", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids", "tree_sort", "cascaded") VALUES ('736049b40cb04b1fb5c2ef5385655ee3', '监督检查问题类别字典值', 'problem_type', '1', '0', '1242684364872761344', '2025-04-16 11:05:56', '1242684364872761344', '2025-04-16 11:05:56', '', NULL, NULL, NULL, '0');

INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('30f8ff1dcf5f4e5bbb914861775e98c1', '736049b40cb04b1fb5c2ef5385655ee3', '1', '五必须', '1', '0', '1242684364872761344', '2025-04-16 11:09:59', '1242684364872761344', '2025-04-16 11:09:59', '', '0', '0,');
INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('50af093c9d6140b4a4b00bb789040d63', '736049b40cb04b1fb5c2ef5385655ee3', '2', '信息的真实性', '2', '0', '1242684364872761344', '2025-04-16 11:10:10', '1242684364872761344', '2025-04-16 11:10:10', '', '0', '0,');
INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('6e3af0c10b9d4f738f33f72b873a85d1', '736049b40cb04b1fb5c2ef5385655ee3', '3', '违章作业', '3', '0', '1242684364872761344', '2025-04-16 11:10:29', '1242684364872761344', '2025-04-16 11:10:29', '', '0', '0,');
INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('35b38e370dc748a3b3eea218919722f1', '736049b40cb04b1fb5c2ef5385655ee3', '4', '劳动组织', '4', '0', '1242684364872761344', '2025-04-16 11:10:37', '1242684364872761344', '2025-04-16 11:10:37', '', '0', '0,');
INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('00346c080d9246698db11036047bf496', '736049b40cb04b1fb5c2ef5385655ee3', '5', '风险管控', '5', '0', '1242684364872761344', '2025-04-16 11:10:44', '1242684364872761344', '2025-04-16 11:10:44', '', '0', '0,');
INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('6ad2e5cc30734197b2e155029af99d2f', '736049b40cb04b1fb5c2ef5385655ee3', '6', '提级管理', '6', '0', '1242684364872761344', '2025-04-16 11:10:53', '1242684364872761344', '2025-04-16 11:10:53', '', '0', '0,');
INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('f68a22c3889b49a3b8f939d0d87d8ebd', '736049b40cb04b1fb5c2ef5385655ee3', '7', '变更管理', '7', '0', '1242684364872761344', '2025-04-16 11:11:02', '1242684364872761344', '2025-04-16 11:11:02', '', '0', '0,');
INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('421d5b5b6ef242d5a69a5e30c98291ab', '736049b40cb04b1fb5c2ef5385655ee3', '8', '视频抽查', '8', '0', '1242684364872761344', '2025-04-16 11:11:12', '1242684364872761344', '2025-04-16 11:11:12', '', '0', '0,');
INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('45f5a92168e642fe8a07e62a56105ade', '736049b40cb04b1fb5c2ef5385655ee3', '9', '其他', '9', '0', '1242684364872761344', '2025-04-16 11:11:20', '1242684364872761344', '2025-04-16 11:11:20', '', '0', '0,');
INSERT INTO "public"."t_sys_dict_data" ("dict_data_id", "dict_id", "dict_key", "dict_value", "tree_sort", "status", "create_by", "create_date", "update_by", "update_date", "remarks", "parent_id", "parent_ids") VALUES ('ff4336e3feb14f5ea3ad447b676ecebd', '736049b40cb04b1fb5c2ef5385655ee3', '10', '建议', '10', '0', '1242684364872761344', '2025-04-16 11:11:27', '1242684364872761344', '2025-04-16 11:11:27', '', '0', '0,');


# 流程图

# 修改流程
hazardousTaskBLDept 流程图
安全管理部门 不为现场确认时 添加条件 ${isOnSiteConfirmation=='0'}


hazardousTaskBLOrg hazardousTaskBLDept hazardousTaskConfinedSpace  hazardousTaskBLDeptConfinedSpace 流程图
修改
安全许可证（审批)-安全分管领导
或企业主要负责人签字 

签字改为审核

# 新增流程图
hazardousTaskStifling
hazardousTaskBLLN2