OA 系统工作流引擎 Camunda 实践（1）

article/2025/10/13 21:28:02

【审核人员看清楚再审核，我是把自己公司的案例分析一下，  这哪是广告？？？】

Camunda是Activiti最大的贡献者之一(除Alfresco以外)，同时也是它一个主 要的执行咨询合作伙伴。camunda表示Activiti可能太拘束于Alfresco对以文档为中心的工作流的需求(这个也是BPMN约束使然)，而忽视了Activiti起步时 的更为普遍的BPM平台。camunda宣布他们正从Activiti 分裂出一个新的开源工程，那就是camunda BPM

官网

https://camunda.com/

下载

https://camunda.com/download/

Camunda文档中文站

http://camunda-cn.shaochenfeng.com/

学习路线知识点

https://www.processon.com/view/link/622da3ba1e085307a23dc108#map

由于公司业务限制，没有用到表单引擎和BPMN.js

模型是后端调用Camunda api（BpmnModelInstance、BpmnDiagram）自动生成的（老板嫌弃BPMN.js画的BPMN图丑），表单引擎比较复杂都是单独写，没用到在线表单生成

目前已实现功能点（国内常见的操作都能实现）：发起，审批通过，驳回，转交他人审批，退回历史节点，前置加签/后置加签，撤回，重新发起，作废，转阅，催办

后面有部分代码，我也业务代码删除了，童鞋们可以参考一下，有疑问可以私信我。

效果图：

流程定义添加

 用户发起：

 

 审批：

 

 后续相关代码实现

// 工作流引擎camunda-bpm依赖
implementation "org.camunda.bpm.springboot:camunda-bpm-spring-boot-starter:7.16.0"
implementation "org.camunda.bpm.springboot:camunda-bpm-spring-boot-starter-webapp:7.16.0"
implementation "org.camunda.bpm:camunda-engine-plugin-spin:7.16.0"
implementation "org.camunda.spin:camunda-spin-dataformat-all:1.16.0"

Camunda工具类

package com.oa.business.flow.utils.camunda;import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.lang.Snowflake;
import cn.hutool.core.util.IdUtil;
import cn.hutool.core.util.ObjectUtil;
import cn.hutool.core.util.StrUtil;
import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import cn.hutool.json.JSONUtil;
import com.galileotime.oa.business.flow.utils.camunda.constant.CamundaEnum;
import com.galileotime.oa.business.flow.utils.camunda.pojo.ProcessPOJO;
import lombok.extern.slf4j.Slf4j;
import org.camunda.bpm.model.bpmn.Bpmn;
import org.camunda.bpm.model.bpmn.BpmnModelInstance;
import org.camunda.bpm.model.bpmn.instance.Process;
import org.camunda.bpm.model.bpmn.instance.*;
import org.camunda.bpm.model.bpmn.instance.bpmndi.BpmnDiagram;
import org.camunda.bpm.model.bpmn.instance.bpmndi.BpmnEdge;
import org.camunda.bpm.model.bpmn.instance.bpmndi.BpmnPlane;
import org.camunda.bpm.model.bpmn.instance.bpmndi.BpmnShape;
import org.camunda.bpm.model.bpmn.instance.camunda.CamundaExecutionListener;
import org.camunda.bpm.model.bpmn.instance.camunda.CamundaTaskListener;
import org.camunda.bpm.model.bpmn.instance.dc.Bounds;
import org.camunda.bpm.model.bpmn.instance.di.Waypoint;
import org.springframework.stereotype.Component;import java.util.HashMap;
import java.util.Iterator;
import java.util.List;/*** @author HeZeMin* @className CamundaUtils* @description Camunda工作流引擎工具类* @date 2022/4/8 15:50*/
@Slf4j
@Component
public class CamundaModelUtils {/**** @Description 创建流程定义* @Return: void* @Author HeZeMin* @Date 2022年04月08日 15:54*/public String createExecutableProcess(HashMap<String, Object> param, Long userId) {ProcessPOJO processPOJO = new ProcessPOJO();BeanUtil.copyProperties(param.get("process"), processPOJO);log.info(JSONUtil.toJsonStr(param));//1、创建一个空的 BPMN 模型实例BpmnModelInstance modelInstance = Bpmn.createEmptyModel();//2、创建BPMN定义元素，设置目标名称空间，并将其添加到新创建的模型实例中Definitions definitions = modelInstance.newInstance(Definitions.class);definitions.setTargetNamespace("http://camunda.org/examples");modelInstance.setDefinitions(definitions);// di-对于图，需要创建一个图和一个平面元素。平面被设置在一个图对象中，图被添加为子元素BpmnDiagram bpmnDiagram = modelInstance.newInstance(BpmnDiagram.class);BpmnPlane plane = modelInstance.newInstance(BpmnPlane.class);bpmnDiagram.setBpmnPlane(plane);definitions.addChildElement(bpmnDiagram);//3、创建流程String procDefKey = CamundaEnum.PROCESS.getName() + this.id();Process process = createElement(definitions, procDefKey, Process.class);process.setName(processPOJO.getProcessName());process.setExecutable(true);//可执行的流程// di-平面元素添加processplane.setBpmnElement(process);//---业务代码处理start//保存流程定义//保存流程发起人用户//保存流程发起人角色//---业务代码处理end//4、创建开始事件StartEvent startEvent = this.createElement(process, CamundaEnum.EVENT.getName() + this.id(), StartEvent.class);startEvent.setCamundaInitiator("initiator");//发起人this.drawBpmnShape(modelInstance, plane, startEvent.getId());// di-平面元素添加节点//5、创建申请人节点UserTask userTask = this.createElement(process, CamundaEnum.ACTIVITY.getName() + this.id(), UserTask.class);userTask.setName("发起人");userTask.setCamundaAssignee("${initiator}");// di-平面元素添加节点this.drawBpmnShape(modelInstance, plane, userTask.getId());// 开始事件连线到申请人节点SequenceFlow sequenceFlow = this.createSequenceFlow(process, startEvent, userTask);// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow.getId());//6、创建结束事件EndEvent endEvent = this.createElement(process, CamundaEnum.EVENT.getName() + this.id(), EndEvent.class);// 结束监听器ExtensionElements extensionElements = this.createElement(endEvent, "", ExtensionElements.class);CamundaExecutionListener start = this.createElement(extensionElements, "", CamundaExecutionListener.class);start.setCamundaDelegateExpression("#{EndEventListener}");start.setCamundaEvent("start");//start||endCamundaExecutionListener end = this.createElement(extensionElements, "", CamundaExecutionListener.class);end.setCamundaDelegateExpression("#{EndEventListener}");end.setCamundaEvent("end");//start||endendEvent.setExtensionElements(extensionElements);this.drawBpmnShape(modelInstance, plane, endEvent.getId());// di-平面元素添加节点//7、处理节点数据-[递归算法]this.iterate(modelInstance, plane, process, userTask, endEvent, null, JSONUtil.toJsonStr(param.get("processModeel")), userId);//8、验证模型Bpmn.validateModel(modelInstance);//9、转换为xml字符串String xmlString = Bpmn.convertToString(modelInstance);log.info(xmlString);return xmlString;}/**** @Description 修改流程定义* @Return: void* @Author HeZeMin* @Date 2022年04月08日 15:54*/public String updateExecutableProcess(HashMap<String, Object> param, Long userId) {ProcessPOJO processPOJO = new ProcessPOJO();BeanUtil.copyProperties(param.get("process"), processPOJO);log.info(JSONUtil.toJsonStr(param));//1、创建一个空的 BPMN 模型实例BpmnModelInstance modelInstance = Bpmn.createEmptyModel();//2、创建BPMN定义元素，设置目标名称空间，并将其添加到新创建的模型实例中Definitions definitions = modelInstance.newInstance(Definitions.class);definitions.setTargetNamespace("http://camunda.org/examples");modelInstance.setDefinitions(definitions);// di-对于图，需要创建一个图和一个平面元素。平面被设置在一个图对象中，图被添加为子元素BpmnDiagram bpmnDiagram = modelInstance.newInstance(BpmnDiagram.class);BpmnPlane plane = modelInstance.newInstance(BpmnPlane.class);bpmnDiagram.setBpmnPlane(plane);definitions.addChildElement(bpmnDiagram);//3、创建流程String procDefKey = processPOJO.getProcDefKey();Process process = createElement(definitions, procDefKey, Process.class);process.setName(processPOJO.getProcessName());process.setExecutable(true);//可执行的流程// di-平面元素添加processplane.setBpmnElement(process);//---业务代码处理start//修改流程定义//流程发起人用户全部逻辑删除//流程发起人角色全部逻辑删除//保存流程发起人用户//保存流程发起人角色//流程节点定义规则全部逻辑删除//流程节点定义用户规则全部逻辑删除//流程网关定义规则全部逻辑删除//流程网关定义条件规则全部逻辑删除//---业务代码处理end//4、创建开始事件StartEvent startEvent = this.createElement(process, CamundaEnum.EVENT.getName() + this.id(), StartEvent.class);startEvent.setCamundaInitiator("initiator");//发起人this.drawBpmnShape(modelInstance, plane, startEvent.getId());// di-平面元素添加节点//5、创建申请人节点UserTask userTask = this.createElement(process, CamundaEnum.ACTIVITY.getName() + this.id(), UserTask.class);userTask.setName("发起人");userTask.setCamundaAssignee("${initiator}");// di-平面元素添加节点this.drawBpmnShape(modelInstance, plane, userTask.getId());// 开始事件连线到申请人节点SequenceFlow sequenceFlow = this.createSequenceFlow(process, startEvent, userTask);// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow.getId());//6、创建结束事件EndEvent endEvent = this.createElement(process, CamundaEnum.EVENT.getName() + this.id(), EndEvent.class);// 结束监听器ExtensionElements extensionElements = this.createElement(endEvent, "", ExtensionElements.class);CamundaExecutionListener start = this.createElement(extensionElements, "", CamundaExecutionListener.class);start.setCamundaDelegateExpression("#{EndEventListener}");start.setCamundaEvent("start");//start||endCamundaExecutionListener end = this.createElement(extensionElements, "", CamundaExecutionListener.class);end.setCamundaDelegateExpression("#{EndEventListener}");end.setCamundaEvent("end");//start||endendEvent.setExtensionElements(extensionElements);this.drawBpmnShape(modelInstance, plane, endEvent.getId());// di-平面元素添加节点//7、处理节点数据-递归this.iterate(modelInstance, plane, process, userTask, endEvent, null, JSONUtil.toJsonStr(param.get("processModeel")), userId);//8、验证模型Bpmn.validateModel(modelInstance);//9、转换为xml字符串String xmlString = Bpmn.convertToString(modelInstance);log.info(xmlString);return xmlString;}/***迭代器* @Description 迭代器* @Param process: 流程DOM对象* @Param previouEvent: 上一节点DOM对象* @Param endEvent: 结束事件DOM对象* @Param conditionMap: 网关条件* @Param jsonStr: 参数json串* @Return: void* @Author HeZeMin* @Date 2022年04月12日 10:35*/public void iterate(BpmnModelInstance modelInstance, BpmnPlane plane, Process process, FlowNode previouEvent, FlowNode endEvent, HashMap<String, String> conditionMap, String jsonStr, Long userId) {JSONObject jsonObject = JSONUtil.parseObj(jsonStr);process.getId();if (ObjectUtil.isNotNull(jsonObject) && jsonObject.size() > 0) {Integer nodeType = jsonObject.get("nodeType", Integer.class);if (1 == nodeType || 2  == nodeType) {// 1=审批人，2=执行人Integer auditType = jsonObject.get("auditType", Integer.class);Integer auditMethod = jsonObject.get("auditMethod", Integer.class);Integer isAdminAudit = jsonObject.get("isAdminAudit", Integer.class);String dataType = jsonObject.get("dataType", String.class);String nodeName = jsonObject.get("nodeName", String.class);String dataValue = jsonObject.get("dataValue", String.class);// 创建用户任务节点String id = CamundaEnum.ACTIVITY.getName() + this.id();if (2  == nodeType) {// 执行人额外增加一个属性标识，不然不知道是执行人还是审批人id = CamundaEnum.ACTIVITY.getName() + "executor_" + this.id();// 执行人标识}UserTask userTask = this.createElement(process, id, UserTask.class);if (2  == nodeType) {userTask.setName(StrUtil.isBlank(nodeName) ? "执行人" : nodeName);} else {userTask.setName(StrUtil.isBlank(nodeName) ? "审批人" : nodeName);}userTask.setCamundaAssignee("${assignee}");// 创建多人签实例MultiInstanceLoopCharacteristics multiInstanceLoopCharacteristics = this.createElement(userTask, "", MultiInstanceLoopCharacteristics.class);//审批人集合参数multiInstanceLoopCharacteristics.setCamundaCollection("assigneeList_" + id);//迭代集合multiInstanceLoopCharacteristics.setCamundaElementVariable("assignee");//完成条件 已完成数等于实例数CompletionCondition completionCondition = this.createElement(multiInstanceLoopCharacteristics, "", CompletionCondition.class);if (0 == auditMethod || 1 == auditMethod) {// 或签completionCondition.setTextContent("${nrOfCompletedInstances == 1}");} else if (2 == auditMethod) {// 会签completionCondition.setTextContent("${nrOfActiveInstances == nrOfInstances}");} else {completionCondition.setTextContent("${nrOfActiveInstances == nrOfInstances}");}multiInstanceLoopCharacteristics.setCompletionCondition(completionCondition);// 并行，为true时就是顺序签if (3 == auditMethod) {multiInstanceLoopCharacteristics.setSequential(true);} else {multiInstanceLoopCharacteristics.setSequential(false);}userTask.setLoopCharacteristics(multiInstanceLoopCharacteristics);// 站内信和提醒 监听器ExtensionElements extensionElements = this.createElement(userTask, "", ExtensionElements.class);CamundaTaskListener create = this.createElement(extensionElements, "", CamundaTaskListener.class);create.setCamundaDelegateExpression("#{TaskMessageListener}");create.setCamundaEvent("create");CamundaTaskListener complete = this.createElement(extensionElements, "", CamundaTaskListener.class);complete.setCamundaDelegateExpression("#{TaskMessageListener}");complete.setCamundaEvent("complete");userTask.setExtensionElements(extensionElements);// di-平面元素添加节点this.drawBpmnShape(modelInstance, plane, userTask.getId());//--相关数据存入数据库start//保存节点//保存节点对应的数据//--相关数据存入数据库endJSONArray nextNodeDataList = (JSONArray) jsonObject.get("nextNodeData");if (CollUtil.isNotEmpty(nextNodeDataList)) {//有下一个节点SequenceFlow sequenceFlow = this.createSequenceFlow(process, previouEvent, userTask, conditionMap);// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow.getId());this.iterate(modelInstance, plane, process, userTask, endEvent, null, JSONUtil.toJsonStr(nextNodeDataList.get(0)), userId);} else {// 没有下一个节点了，连线结束事件SequenceFlow sequenceFlow = this.createSequenceFlow(process, previouEvent, userTask, conditionMap);SequenceFlow sequenceFlow1 = this.createSequenceFlow(process, userTask, endEvent);// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow.getId());// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow1.getId());}} else if (3 == nodeType) {// 3=抄送人Integer auditType = jsonObject.get("auditType", Integer.class);Integer auditMethod = jsonObject.get("auditMethod", Integer.class);Integer isAdminAudit = jsonObject.get("isAdminAudit", Integer.class);String dataType = jsonObject.get("dataType", String.class);String dataValue = jsonObject.get("dataValue", String.class);String nodeName = jsonObject.get("nodeName", String.class);// 创建用户任务节点String id = CamundaEnum.ACTIVITY.getName() + "copy_" + this.id();UserTask userTask = this.createElement(process, id, UserTask.class);userTask.setName(StrUtil.isBlank(nodeName) ? "抄送人" : nodeName);// 抄送监听器ExtensionElements extensionElements = this.createElement(userTask, "", ExtensionElements.class);CamundaTaskListener create = this.createElement(extensionElements, "", CamundaTaskListener.class);create.setCamundaDelegateExpression("#{CopyListener}");create.setCamundaEvent("create");CamundaTaskListener complete = this.createElement(extensionElements, "", CamundaTaskListener.class);complete.setCamundaDelegateExpression("#{CopyListener}");complete.setCamundaEvent("complete");userTask.setExtensionElements(extensionElements);// di-平面元素添加节点this.drawBpmnShape(modelInstance, plane, userTask.getId());//--相关数据存入数据库//保存节点//保存节点对应的数据//--相关数据存入数据库JSONArray nextNodeDataList = (JSONArray) jsonObject.get("nextNodeData");if (CollUtil.isNotEmpty(nextNodeDataList)) {//有下一个节点SequenceFlow sequenceFlow = this.createSequenceFlow(process, previouEvent, userTask, conditionMap);// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow.getId());this.iterate(modelInstance, plane, process, userTask, endEvent, null, JSONUtil.toJsonStr(nextNodeDataList.get(0)), userId);} else {// 没有下一个节点了，连线结束事件SequenceFlow sequenceFlow = this.createSequenceFlow(process, previouEvent, userTask, conditionMap);SequenceFlow sequenceFlow1 = this.createSequenceFlow(process, userTask, endEvent);// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow.getId());// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow1.getId());}} else if (4 == nodeType){// 4=条件分支，只有网关才会有下一节点数据和条件判断数据同时出现的情况String nodeName = jsonObject.get("nodeName", String.class);// 创建网关String id = CamundaEnum.GATEWAY.getName() + this.id();// 专属网关，直走一个条件ExclusiveGateway gateway = this.createElement(process, id, ExclusiveGateway.class);// 并行网关，所有条件都走
//                ParallelGateway gateway = createElement(process, id, ParallelGateway.class);SequenceFlow sequenceFlow = this.createSequenceFlow(process, previouEvent, gateway, conditionMap);// di-平面元素添加节点this.drawBpmnShape(modelInstance, plane, gateway.getId());// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow.getId());//--相关数据存入数据库start// 保存网关节点//--相关数据存入数据库end// 条件判断集合JSONArray conditionList = (JSONArray) jsonObject.get("conditionList");Iterator<Object> iterator = conditionList.iterator();while (iterator.hasNext()) {JSONObject condition = (JSONObject) iterator.next();//--相关数据存入数据库start// 保存网关节点条件判断//--相关数据存入数据库end// 网关表达式StringBuilder textContent = new StringBuilder();textContent.append("${");if (StrUtil.isNotBlank(condition.get("conditionKey_", String.class))) {//两个条件textContent.append("(");if (StrUtil.contains("区间", condition.get("operator", String.class))) {textContent.append(condition.get("targetValue1", String.class) + condition.get("targetValue1Operator", String.class) + condition.get("conditionKey", String.class)).append(" && ").append(condition.get("conditionKey", String.class) + condition.get("targetValue2Operator", String.class) + condition.get("targetValue2", String.class));} else if (StrUtil.contains("包含", condition.get("operator", String.class))) {List<String> stringList = StrUtil.split(condition.get("targetValue", String.class), ",");for (int i = 0; i < stringList.size(); i++) {String targetValue = stringList.get(i);if (i == 0) {textContent.append(condition.get("conditionKey", String.class) + " == " + targetValue);} else {textContent.append(" || ");textContent.append(condition.get("conditionKey", String.class) + " == " + targetValue);}}} else if (StrUtil.contains("不包含", condition.get("operator", String.class))) {List<String> stringList = StrUtil.split(condition.get("targetValue", String.class), ",");for (int i = 0; i < stringList.size(); i++) {String targetValue = stringList.get(i);if (i == 0) {textContent.append(condition.get("conditionKey", String.class) + " != " + targetValue);} else {textContent.append(" && ");textContent.append(condition.get("conditionKey", String.class) + " != " + targetValue);}}} else {textContent.append(condition.get("conditionKey", String.class) + condition.get("operator", String.class) + condition.get("targetValue", String.class));}textContent.append(") && (");if (StrUtil.contains("区间", condition.get("operator_", String.class))) {textContent.append(condition.get("targetValue1_", String.class) + condition.get("targetValue1Operator_", String.class) + condition.get("conditionKey_", String.class)).append(" && ").append(condition.get("conditionKey_", String.class) + condition.get("targetValue2Operator_", String.class) + condition.get("targetValue2_", String.class));} else if (StrUtil.contains("包含", condition.get("operator_", String.class))) {List<String> stringList = StrUtil.split(condition.get("targetValue_", String.class), ",");for (int i = 0; i < stringList.size(); i++) {String targetValue = stringList.get(i);if (i == 0) {textContent.append(condition.get("conditionKey_", String.class) + " == " + targetValue);} else {textContent.append(" || ");textContent.append(condition.get("conditionKey_", String.class) + " == " + targetValue);}}} else if (StrUtil.contains("不包含", condition.get("operator_", String.class))) {List<String> stringList = StrUtil.split(condition.get("targetValue_", String.class), ",");for (int i = 0; i < stringList.size(); i++) {String targetValue = stringList.get(i);if (i == 0) {textContent.append(condition.get("conditionKey_", String.class) + " != " + targetValue);} else {textContent.append(" && ");textContent.append(condition.get("conditionKey_", String.class) + " != " + targetValue);}}} else {textContent.append(condition.get("conditionKey_", String.class) + condition.get("operator_", String.class) + condition.get("targetValue_", String.class));}textContent.append(")");} else {// 一个条件if (StrUtil.contains("区间", condition.get("operator", String.class))) {textContent.append(condition.get("targetValue1", String.class) + condition.get("targetValue1Operator", String.class) + condition.get("conditionKey", String.class)).append(" && ").append(condition.get("conditionKey", String.class) + condition.get("targetValue2Operator", String.class) + condition.get("targetValue2", String.class));} else if (StrUtil.contains("包含", condition.get("operator", String.class))) {List<String> stringList = StrUtil.split(condition.get("targetValue", String.class), ",");for (int i = 0; i < stringList.size(); i++) {String targetValue = stringList.get(i);if (i == 0) {textContent.append(condition.get("conditionKey", String.class) + " == " + targetValue);} else {textContent.append(" || ");textContent.append(condition.get("conditionKey", String.class) + " == " + targetValue);}}} else if (StrUtil.contains("不包含", condition.get("operator", String.class))) {List<String> stringList = StrUtil.split(condition.get("targetValue", String.class), ",");for (int i = 0; i < stringList.size(); i++) {String targetValue = stringList.get(i);if (i == 0) {textContent.append(condition.get("conditionKey", String.class) + " != " + targetValue);} else {textContent.append(" && ");textContent.append(condition.get("conditionKey", String.class) + " != " + targetValue);}}} else {textContent.append(condition.get("conditionKey", String.class) + condition.get("operator", String.class) + condition.get("targetValue", String.class));}}textContent.append("}");JSONArray nextNodeDataList = (JSONArray) condition.get("nextNodeData");if (CollUtil.isNotEmpty(nextNodeDataList)) {//有下一个节点String conditionName = condition.get("conditionName", String.class);HashMap<String, String> map = new HashMap<>();map.put("name", StrUtil.isBlank(conditionName) ? textContent.toString() : conditionName);map.put("type", "");map.put("textContent", textContent.toString());this.iterate(modelInstance, plane, process, gateway, endEvent, map, JSONUtil.toJsonStr(nextNodeDataList.get(0)), userId);} else {SequenceFlow sequenceFlow1 = this.createSequenceFlow(process, gateway, endEvent);// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow1.getId());// 一下注释代码暂时用不到，勿删// 网关的下一个节点，不是条件下的
//                        JSONArray gatewayNnextNodeDataList = (JSONArray) jsonObject.get("nextNodeData");
//                        if (CollUtil.isNotEmpty(gatewayNnextNodeDataList)) {//有下一个节点
//                            this.createSequenceFlow(process, startEvent, gateway, conditionMap);
//                            this.iterate(process, gateway, endEvent, null, JSONUtil.toJsonStr(gatewayNnextNodeDataList.get(0)));
//                        } else {// 没有下一个节点了，连线结束事件
//                            this.createSequenceFlow(process, gateway, endEvent, conditionMap);
//                        }}}}} else {// 开始事件连线到结束事件SequenceFlow sequenceFlow = this.createSequenceFlow(process, previouEvent, endEvent);// di-平面元素添加连线this.drawBpmnEdge(modelInstance, plane, sequenceFlow.getId());}}/*** Description:id生成器* @Author HeZeMin* @Date 2022年04月21日 15:25*/protected String id() {Snowflake snowflake = IdUtil.getSnowflake(1, 1);return snowflake.nextIdStr();}/*** Description:创建元素-在父元素下创建子元素-* @Author HeZeMin* @Date 2022年04月21日 15:24*/protected <T extends BpmnModelElementInstance> T createElement(BpmnModelElementInstance parentElement, String id, Class<T> elementClass) {T element = parentElement.getModelInstance().newInstance(elementClass);if (StrUtil.isNotBlank(id)) {element.setAttributeValue("id", id, true);}parentElement.addChildElement(element);return element;}/*** Description:创建元素-在父元素下创建子元素，需要传元素属性* @Author HeZeMin* @Date 2022年04月21日 15:24*/protected <T extends BpmnModelElementInstance> T createElement(BpmnModelElementInstance parentElement, HashMap<String, String> params, Class<T> elementClass) {T element = parentElement.getModelInstance().newInstance(elementClass);if (CollUtil.isNotEmpty(params)) {params.forEach((key, value) -> {if ("id".equals(key)) {element.setAttributeValue("id", value, true);} else {element.setAttributeValue(key, value);}});}parentElement.addChildElement(element);return element;}/*** Description:创建线条元素-元素之间的连接线* @Author HeZeMin* @Date 2022年04月21日 14:42*/protected SequenceFlow createSequenceFlow(Process process, FlowNode from, FlowNode to) {String identifier = from.getId() + "-" + to.getId();SequenceFlow sequenceFlow = this.createElement(process, identifier, SequenceFlow.class);process.addChildElement(sequenceFlow);sequenceFlow.setSource(from);from.getOutgoing().add(sequenceFlow);sequenceFlow.setTarget(to);to.getIncoming().add(sequenceFlow);return sequenceFlow;}/*** Description:创建线条元素-网关元素之间的连接线，需要传判断条件* @Author HeZeMin* @Date 2022年04月21日 14:41*/protected SequenceFlow createSequenceFlow(Process process, FlowNode from, FlowNode to, HashMap<String, String> conditionMap) {String identifier = from.getId() + "-" + to.getId();SequenceFlow sequenceFlow = this.createElement(process, identifier, SequenceFlow.class);process.addChildElement(sequenceFlow);sequenceFlow.setSource(from);from.getOutgoing().add(sequenceFlow);sequenceFlow.setTarget(to);to.getIncoming().add(sequenceFlow);// 判断是否有连线条件if (CollUtil.isNotEmpty(conditionMap)) {//  set条件sequenceFlow.setName(conditionMap.get("name"));ConditionExpression conditionExpression = this.createElement(sequenceFlow, "", ConditionExpression.class);
//            conditionExpression.setType(conditionMap.get("type"));conditionExpression.setTextContent(conditionMap.get("textContent"));sequenceFlow.setConditionExpression(conditionExpression);}return sequenceFlow;}/*** Description:绘制节点* @Author HeZeMin* @Date 2022年04月21日 14:39*/protected void drawBpmnShape(BpmnModelInstance modelInstance, BpmnPlane plane, String elementById) {BpmnShape bpmnShape = modelInstance.newInstance(BpmnShape.class);BaseElement element1 = modelInstance.getModelElementById(elementById);bpmnShape.setBpmnElement(element1);bpmnShape.setId(elementById + "_di");Bounds bounds = modelInstance.newInstance(Bounds.class);bounds.setX(150);bounds.setY(80);bounds.setHeight(80);bounds.setWidth(100);if (element1 instanceof ExclusiveGateway) {bpmnShape.setMarkerVisible(true);}bpmnShape.setBounds(bounds);plane.addChildElement(bpmnShape);}/*** Description:绘制连线* @Author HeZeMin* @Date 2022年04月21日 14:40*/protected void drawBpmnEdge(BpmnModelInstance modelInstance, BpmnPlane plane, String elementById) {BpmnEdge bpmnEdge = modelInstance.newInstance(BpmnEdge.class);BaseElement element0 = modelInstance.getModelElementById(elementById);bpmnEdge.setId(elementById + "_di");bpmnEdge.setBpmnElement(element0);Waypoint wp1 = modelInstance.newInstance(Waypoint.class);wp1.setX(300);wp1.setY(100);bpmnEdge.addChildElement(wp1);Waypoint wp2 = modelInstance.newInstance(Waypoint.class);wp2.setX(300);wp2.setY(100);bpmnEdge.addChildElement(wp2);plane.addChildElement(bpmnEdge);}
}
package com.oa.business.flow.utils.camunda;import cn.hutool.core.collection.CollUtil;
import cn.hutool.json.JSONObject;
import cn.hutool.json.JSONUtil;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.camunda.bpm.engine.*;
import org.camunda.bpm.engine.history.HistoricVariableInstance;
import org.camunda.bpm.engine.impl.RepositoryServiceImpl;
import org.camunda.bpm.engine.impl.bpmn.behavior.UserTaskActivityBehavior;
import org.camunda.bpm.engine.impl.el.ExpressionManager;
import org.camunda.bpm.engine.impl.javax.el.ExpressionFactory;
import org.camunda.bpm.engine.impl.javax.el.ValueExpression;
import org.camunda.bpm.engine.impl.juel.ExpressionFactoryImpl;
import org.camunda.bpm.engine.impl.juel.SimpleContext;
import org.camunda.bpm.engine.impl.persistence.entity.ProcessDefinitionEntity;
import org.camunda.bpm.engine.impl.pvm.PvmActivity;
import org.camunda.bpm.engine.impl.pvm.PvmTransition;
import org.camunda.bpm.engine.impl.pvm.process.ActivityImpl;
import org.camunda.bpm.engine.impl.task.TaskDefinition;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;import java.util.*;
import java.util.concurrent.CopyOnWriteArrayList;
import java.util.stream.Collectors;/*** Camunda节点操作工具类* @author HeZeMin* @className CamundaNodeUtils* @date 2022/6/22 15:01*/
@Slf4j
@Component
public class CamundaNodeUtils {@AutowiredRepositoryService repositoryService;// 部署服务@AutowiredRuntimeService runtimeService;// 运行服务@AutowiredIdentityService identityService;// 用户服务@AutowiredAuthorizationService authorizationService;// 授权服务@AutowiredTaskService taskService;// 任务服务@AutowiredHistoryService historyService;// 历史服务/*** Description:根据流程实例ID查询审批节点集合* @Author HeZeMin* @Date 2022年06月22日 17:05*/public List<JSONObject> simulationNextPath(String processInstanceId, boolean isHistoric) {log.debug("-------------------------------------------------------");Map<String, Object> condition = new HashMap<>();if (isHistoric) {List<HistoricVariableInstance> variableInstanceList = historyService.createHistoricVariableInstanceQuery().processInstanceId(processInstanceId).list();condition = new HashMap<>(variableInstanceList.size());for (int i = 0; i < variableInstanceList.size(); i++) {condition.put(variableInstanceList.get(i).getName(), variableInstanceList.get(i).getValue());}} else {condition = runtimeService.getVariables(processInstanceId);}log.debug("condition---->" + JSONUtil.toJsonStr(condition));List<TaskDefinition> tasks = null;try {tasks = this.getNextTaskInfos(processInstanceId, condition, isHistoric);} catch (Exception e) {e.printStackTrace();}log.debug("----------->" + JSONUtil.toJsonStr(tasks));List<JSONObject> ja = new ArrayList<>();if (CollUtil.isNotEmpty(tasks)) {for (TaskDefinition task : tasks) {JSONObject jo = new JSONObject();jo.set("key", task.getKey());jo.set("name", task.getNameExpression().getExpressionText());jo.set("assignment", task.getAssigneeExpression() == null ? "" : task.getAssigneeExpression().getExpressionText());ja.add(jo);}}log.debug("----->" + ja.toString());log.debug("-------------------------------------------------------");return ja;}/*** 获取下一个节点任务信息** @param processInstanceId*            流程实例ID* @return 下一个节点信息* @throws Exception*/public List<TaskDefinition> getNextTaskInfos(String processInstanceId, Map<String, Object> condition, boolean isHistoric) {ProcessDefinitionEntity processDefinitionEntity = null;List<TaskDefinition> tasks = new CopyOnWriteArrayList<TaskDefinition>();// 获取流程发布Id信息String definitionId = "";if (isHistoric) {definitionId = historyService.createHistoricProcessInstanceQuery().processInstanceId(processInstanceId).singleResult().getProcessDefinitionId();} else {definitionId = runtimeService.createProcessInstanceQuery().processInstanceId(processInstanceId).singleResult().getProcessDefinitionId();}processDefinitionEntity = (ProcessDefinitionEntity) ((RepositoryServiceImpl) repositoryService).getDeployedProcessDefinition(definitionId);// 获取流程所有节点信息List<ActivityImpl> activitiList = processDefinitionEntity.getActivities();activitiList = activitiList.stream().filter(activity -> activity.getProperty("type").equals("startEvent")).collect(Collectors.toList());this.nextTaskDefinitions(tasks, activitiList, activitiList.get(0).getId(), processInstanceId, condition);return tasks;}private List<TaskDefinition> nextTaskDefinitions(List<TaskDefinition> tasks, List<ActivityImpl> activityList, String activityId,String processInstanceId, Map<String, Object> condition) {activityList.forEach(activity -> {PvmActivity ac = null;Object expression = null;// 表达式log.debug("activityImpl.getActivityId()---->"+activity.getActivityId()+"---activityId---------->"+activityId+"--->"+activity.getProperty("type"));// 如果遍历节点为用户任务并且节点不是当前节点信息if ("userTask".equals(activity.getProperty("type")) && !activityId.equals(activity.getId())) {// 获取该节点下一个节点信息TaskDefinition taskDefinition = ((UserTaskActivityBehavior) activity.getActivityBehavior()).getTaskDefinition();tasks.add(taskDefinition);List<PvmTransition> outTransitions = activity.getOutgoingTransitions();List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add((ActivityImpl)(outTransitions.get(0).getDestination()));this.nextTaskDefinitions(tasks, activityListTmp, activityListTmp.get(0).getId(), processInstanceId, condition);}else if (activity.getProperty("type").toString().contains("EndEvent") && !activityId.equals(activity.getId())) {// 设置结束节点TaskDefinition taskDefinition = new TaskDefinition(null);ExpressionManager expressionManager = new ExpressionManager();taskDefinition.setKey(activity.getId() == null ? "end" : activity.getId());String name = activity.getProperty("name") == null ? "结束" : activity.getProperty("name").toString();taskDefinition.setNameExpression(expressionManager.createExpression(name));
//                    taskDefinitions.add(taskDefinition);} else if ("multiInstanceBody".equals(activity.getProperty("type")) && !activityId.equals(activity.getId())) {// 获取该节点下一个节点信息List<ActivityImpl> list = ((ActivityImpl) activity).getActivities();for(ActivityImpl act : list){//log.debug("act-------------->"+act.getActivityBehavior().getClass().getTypeName());TaskDefinition taskDefinition = ((UserTaskActivityBehavior) act.getActivityBehavior()).getTaskDefinition();tasks.add(taskDefinition);}List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add((ActivityImpl) activity);this.nextTaskDefinitions(tasks, activityListTmp, activityListTmp.get(0).getId(), processInstanceId, condition);// 当前节点为exclusiveGateway或inclusiveGateway} else if ("exclusiveGateway".equals(activity.getProperty("type")) || "inclusiveGateway".equals(activity.getProperty("type"))) {List<PvmTransition> outTransitions = activity.getOutgoingTransitions();String defaultTransition = (String) activity.getProperty("default");if (outTransitions.size() == 1) {List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add((ActivityImpl) outTransitions.get(0).getDestination());this.nextTaskDefinitions(tasks, activityListTmp,activityListTmp.get(0).getId(), processInstanceId, condition);} else if (outTransitions.size() > 1) { // 如果排他网关有多条线路信息for (PvmTransition tr1 : outTransitions) {ActivityImpl actImpl = (ActivityImpl) tr1.getDestination();if (actImpl.getProperty("type").toString().contains("EndEvent")) {TaskDefinition taskDefinition = new TaskDefinition(null);ExpressionManager expressionManager = new ExpressionManager();taskDefinition.setKey(actImpl.getId() == null ? "end" : actImpl.getId());String name = actImpl.getProperty("name") == null ? "结束" : actImpl.getProperty("name").toString();taskDefinition.setNameExpression(expressionManager.createExpression(name));
//                                taskDefinitions.add(taskDefinition);break;}expression = tr1.getProperty("conditionText"); // 获取排他网关线路判断条件信息if (null == expression) {continue;}// 判断el表达式是否成立if (isCondition(condition, StringUtils.trim(expression.toString()))) {List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add(actImpl);this.nextTaskDefinitions(tasks, activityListTmp, "", processInstanceId, condition);}}}} else if ("parrallelGateway".equals(activity.getProperty("type"))) {List<PvmTransition> outTransitions = activity.getOutgoingTransitions();for (PvmTransition tr1 : outTransitions) {List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add((ActivityImpl) tr1.getDestination());this.nextTaskDefinitions(tasks, activityListTmp,activityListTmp.get(0).getId(), processInstanceId, condition);}} else {//***************************************************************// 获取节点所有流向线路信息List<PvmTransition> outTransitions = activity.getOutgoingTransitions();List<PvmTransition> outTransitionsTemp = null;for (PvmTransition tr : outTransitions) {ac = tr.getDestination(); // 获取线路的终点节点log.debug("ac----------->" + ac.getId() + "------>" + ac.getProperty("type"));// 如果流向线路为排他网关或包容网关if ("exclusiveGateway".equals(ac.getProperty("type")) || "inclusiveGateway".equals(ac.getProperty("type"))) {outTransitionsTemp = ac.getOutgoingTransitions();String defaultTransition = (String) ac.getProperty("default");// 如果排他网关只有一条线路信息if (outTransitionsTemp.size() == 1) {List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add((ActivityImpl) outTransitionsTemp.get(0).getDestination());this.nextTaskDefinitions(tasks, activityListTmp,activityListTmp.get(0).getId(), processInstanceId, condition);} else if (outTransitionsTemp.size() > 1) { // 如果排他网关有多条线路信息for (PvmTransition tr1 : outTransitionsTemp) {PvmActivity ac1 = tr1.getDestination();ActivityImpl actImpl = (ActivityImpl) ac1;if (actImpl.getProperty("type").toString().contains("EndEvent")) {TaskDefinition taskDefinition2 = new TaskDefinition(null);ExpressionManager expressionManager2 = new ExpressionManager();taskDefinition2.setKey(actImpl.getId() == null ? "end" : actImpl.getId());String name2 = actImpl.getProperty("name") == null ? "结束" : actImpl.getProperty("name").toString();taskDefinition2.setNameExpression(expressionManager2.createExpression(name2));
//                                        taskDefinitions.add(taskDefinition2);break;}expression = tr1.getProperty("conditionText"); // 获取排他网关线路判断条件信息if (null == expression) {continue;}// 判断el表达式是否成立if (this.isCondition(condition, StringUtils.trim(expression.toString()))) {List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add(actImpl);this.nextTaskDefinitions(tasks, activityListTmp,"", processInstanceId, condition);}}}} else if ("userTask".equals(ac.getProperty("type"))) {tasks.add(((UserTaskActivityBehavior) ((ActivityImpl) ac).getActivityBehavior()).getTaskDefinition());TaskDefinition taskDefinition = ((UserTaskActivityBehavior) ((ActivityImpl) ac).getActivityBehavior()).getTaskDefinition();List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add((ActivityImpl) ac);this.nextTaskDefinitions(tasks, activityListTmp,activityListTmp.get(0).getId(), processInstanceId, condition);} else if ("multiInstanceBody".equals(ac.getProperty("type"))) {List<ActivityImpl> list = ((ActivityImpl) ac).getActivities();for(ActivityImpl act : list){//log.debug("act-------------->"+act.getActivityBehavior().getClass().getTypeName());TaskDefinition taskDefinition = ((UserTaskActivityBehavior) act.getActivityBehavior()).getTaskDefinition();tasks.add(taskDefinition);}List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add((ActivityImpl) ac);this.nextTaskDefinitions(tasks, activityListTmp,activityListTmp.get(0).getId(), processInstanceId, condition);} else if (ac.getProperty("type").toString().contains("EndEvent")) {// 设置结束节点TaskDefinition taskDefinition = new TaskDefinition(null);ExpressionManager expressionManager = new ExpressionManager();taskDefinition.setKey(ac.getId() == null ? "end" : ac.getId());String name = ac.getProperty("name") == null ? "结束" : ac.getProperty("name").toString();taskDefinition.setNameExpression(expressionManager.createExpression(name));
//                            taskDefinitions.add(taskDefinition);} else if ("parrallelGateway".equals(ac.getProperty("type"))) {List<PvmTransition> poutTransitions = ac.getOutgoingTransitions();for (PvmTransition tr1 : poutTransitions) {tasks.add(((UserTaskActivityBehavior) ((ActivityImpl) ac).getActivityBehavior()).getTaskDefinition());List<ActivityImpl> activityListTmp = new ArrayList<>();activityListTmp.add((ActivityImpl) ac);this.nextTaskDefinitions(tasks, activityListTmp, "", processInstanceId, condition);}}}}
//                return taskDefinitions;});return null;}private boolean isCondition(Map<String, Object> condition, String expression) {try {ExpressionFactory factory = new ExpressionFactoryImpl();SimpleContext context = new SimpleContext();if (condition != null) {Iterator<Map.Entry<String, Object>> iterator = condition.entrySet().iterator();while (iterator.hasNext()) {Map.Entry<String, Object> value = iterator.next();context.setVariable(value.getKey(), factory.createValueExpression(value.getValue(), String.class));}}ValueExpression e = factory.createValueExpression(context, expression, boolean.class);return (Boolean) e.getValue(context);} catch (Exception e) {log.error("operation error");throw e;}}
}
package com.oa.business.flow.utils.camunda;import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.util.ObjectUtil;
import cn.hutool.core.util.StrUtil;
import cn.hutool.json.JSONObject;
import lombok.extern.slf4j.Slf4j;
import org.camunda.bpm.engine.*;
import org.camunda.bpm.engine.history.HistoricActivityInstance;
import org.camunda.bpm.engine.history.HistoricTaskInstance;
import org.camunda.bpm.engine.impl.RepositoryServiceImpl;
import org.camunda.bpm.engine.impl.persistence.entity.ProcessDefinitionEntity;
import org.camunda.bpm.engine.impl.pvm.process.ActivityImpl;
import org.camunda.bpm.engine.repository.Deployment;
import org.camunda.bpm.engine.runtime.ActivityInstance;
import org.camunda.bpm.engine.runtime.ProcessInstance;
import org.camunda.bpm.engine.runtime.ProcessInstanceModificationBuilder;
import org.camunda.bpm.engine.task.Task;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;import java.util.*;
import java.util.stream.Collectors;/*** @author HeZeMin* @className CamundaServiceUtils* @description Camunda服务工具类* @date 2022/4/12 11:44*/
@Slf4j
@Component
public class CamundaServiceUtils {@AutowiredRepositoryService repositoryService;// 部署服务@AutowiredRuntimeService runtimeService;// 运行服务@AutowiredIdentityService identityService;// 用户服务@AutowiredAuthorizationService authorizationService;// 授权服务@AutowiredTaskService taskService;// 任务服务@AutowiredHistoryService historyService;// 历史服务@AutowiredManagementService managementService;// 1、部署流程定义public JSONObject deployProcess(JSONObject params) {// 获取参数String name = params.get("processName", String.class);String bpmnXmlStr = params.get("bpmnXmlStr", String.class);// 部署流程定义Deployment deployment = repositoryService.createDeployment().name(name).addString(name + ".bpmn20.xml", bpmnXmlStr).deploy();
//        managementService.registerProcessApplication(deployment.getId(), Context.getCurrentProcessApplication());// 封装返回结果集JSONObject res = new JSONObject();res.set("deploymentId", deployment.getId());res.set("deploymentName", deployment.getName());return  res;}// 2、启动流程实例public JSONObject startProcess(Map<String, Object> params) {String initiator = (String) params.get("initiator");String processDefinitionKey = (String) params.get("processDefinitionKey");String businessKey = (String) params.get("businessKey");Map<String, Object> variables = (Map<String, Object>) params.get("variables");// 设置发起人identityService.setAuthenticatedUserId(initiator);// 启动流程定义ProcessInstance simpleTest = runtimeService.startProcessInstanceByKey(processDefinitionKey, businessKey, variables);if (ObjectUtil.isNull(simpleTest)) {return null;}// 自动跳过发起人节点
//        List<Task> list = taskService.createTaskQuery().taskAssignee(initiator).processInstanceId(simpleTest.getId()).list();
//        if (CollUtil.isNotEmpty(list)) {
//            taskService.complete(list.get(0).getId());
//        }// 结果集封装JSONObject res = new JSONObject();res.set("processInstanceId", simpleTest.getId());res.set("initiator", initiator);res.set("processInstanceParentId", simpleTest.getProcessInstanceId());res.set("processDefinitionId", simpleTest.getProcessDefinitionId());return  res;}// 3、审批同意public JSONObject pass(JSONObject params) {// 获取变量String taskId = params.get("taskId", String.class);String userId = params.get("userId", String.class);String processInstanceId = params.get("processInstanceId", String.class);String comment = params.get("comment", String.class);Map<String, Object> variables = params.get("variables", Map.class);// 添加审批人identityService.setAuthenticatedUserId(userId);// 判断是否有审批意见if (StrUtil.isNotBlank(comment)) {// 提交审批意见taskService.createComment(taskId, processInstanceId, comment);}// 完成当前任务实例taskService.complete(taskId, variables);// 结果集封装JSONObject res = new JSONObject();return res;}// 4、审批拒绝public JSONObject reject(JSONObject params) {// 获取变量String taskId = params.get("taskId", String.class);String processInstanceId = params.get("processInstanceId", String.class);String userId = params.get("userId", String.class);String comment = params.get("comment", String.class);// 添加审批人identityService.setAuthenticatedUserId(userId);// 获取当前任务，未办理任务idHistoricTaskInstance currTask = historyService.createHistoricTaskInstanceQuery().taskId(taskId).singleResult();if (ObjectUtil.isNull(currTask)) {log.error("没有查询到审批任务");JSONObject res = new JSONObject();res.set("msg", "没有查询到审批任务");return res;}// 驳回审批意见taskService.createComment(taskId, currTask.getProcessInstanceId(), comment);//获取流程实例ProcessInstance processInstance = runtimeService.createProcessInstanceQuery().processInstanceId(currTask.getProcessInstanceId()).singleResult();//获取流程定义ProcessDefinitionEntity processDefinitionEntity = (ProcessDefinitionEntity) ((RepositoryServiceImpl) repositoryService).getDeployedProcessDefinition(currTask.getProcessDefinitionId());ActivityImpl currentActivity = (processDefinitionEntity).findActivity(currTask.getTaskDefinitionKey());// 获取起始活动List<HistoricActivityInstance> historicActivityInstances = historyService.createHistoricActivityInstanceQuery().activityType("userTask").processInstanceId(processInstanceId).finished().orderByHistoricActivityInstanceEndTime().asc().list();if(historicActivityInstances.size() == 0){JSONObject res = new JSONObject();return res;}// 起始节点活动ActivityImpl lastActivity = processDefinitionEntity.findActivity(historicActivityInstances.get(0).getActivityId());// 退回至起点申请人runtimeService.createProcessInstanceModification(processInstanceId)// 关闭当前活动任务节点.cancelAllForActivity(currentActivity.getActivityId()).setAnnotation("驳回")// 启动申请人节点.startBeforeActivity(lastActivity.getActivityId()).execute();// 结果集封装JSONObject res = new JSONObject();return res;}// 5、转交public JSONObject transfer(JSONObject params) {// 获取变量String taskId = params.get("taskId", String.class);String userId = params.get("userId", String.class);Date transferTime = params.get("transferTime", Date.class);// 添加审批人identityService.setAuthenticatedUserId(userId);// 委托他人taskService.delegateTask(taskId, userId);JSONObject res = new JSONObject();return res;}// 6、退回public JSONObject returnOldTask(JSONObject params) {// 获取变量String taskId = params.get("taskId", String.class);String processInstanceId = params.get("processInstanceId", String.class);String targetActivityId = params.get("targetActivityId", String.class);String comment = params.get("comment", String.class);// 退回意见taskService.createComment(taskId, processInstanceId, comment);//获取当前环节实例ProcessInstanceModificationBuilder processInstanceModificationBuilder = runtimeService.createProcessInstanceModification(processInstanceId);Set<String> activityIdSet = new HashSet<>();taskService.createTaskQuery().processInstanceId(processInstanceId).active().list().forEach(taskQuery -> {String activityId = taskQuery.getTaskDefinitionKey();if(activityIdSet.add(activityId)){processInstanceModificationBuilder.cancelAllForActivity(activityId);}});
//        ArrayList<String> userIds = (ArrayList<String>) runtimeService.getVariable(processInstanceId, "assigneeList_" + targetActivityId);
//        log.info(JSONUtil.toJsonStr(userIds));
//        Map<String, Object> vars = new HashMap<String, Object>(1);
//        vars.put("assigneeList_" + targetActivityId, userIds);processInstanceModificationBuilder.startBeforeActivity(targetActivityId + "#multiInstanceBody")
//                .setVariable("assigneeList_" + targetActivityId, userIds)
//                .setVariable("assignee", "${assignee}")
//                .setVariablesLocal(map).execute();JSONObject res = new JSONObject();return res;}// 7、加签（前后都能加）public JSONObject addSignature(JSONObject params) {JSONObject res = new JSONObject();// 获取变量String userId = params.get("userId", String.class);// 当前用户idString taskId = params.get("taskId", String.class);// 当前任务idString processInstanceId = params.get("processInstanceId", String.class);// 当前流程实例idString comment = params.get("comment", String.class);// 加签意见Integer type = params.get("type", Integer.class);// 加签类型（1=前置加签，2=后置加签）String addUserId = params.get("addUserId", String.class);// 加签用户idInteger auditMethod = params.get("auditMethod", Integer.class);// // 审批类型：1=或签，2=会签，3=顺序签// 获取当前任务，未办理任务idHistoricTaskInstance currTask = historyService.createHistoricTaskInstanceQuery().taskId(taskId).singleResult();if (ObjectUtil.isNull(currTask)) {log.error("没有查询到审批任务,只有任务所属人才可以加签");return null;}// 加签意见taskService.createComment(taskId, currTask.getProcessInstanceId(), comment);// 获取当前活动实例ActivityInstance activity = runtimeService.getActivityInstance(processInstanceId);ActivityInstance[] childActivityInstances = activity.getChildActivityInstances();ActivityInstance childActivityInstance = childActivityInstances[0];String activityId = childActivityInstance.getActivityId().split("#")[0];// 获取到原来的人员变量，进行加签List<String> variableList = (List<String>) runtimeService.getVariableLocal(currTask.getProcessInstanceId(), "assigneeList_" + activityId);
//        if (variableList.size() > 1) {
//            System.out.println("该节点审批人数超过一个，无法加签");
//        }LinkedList<String> linkedList = variableList.stream().collect(Collectors.toCollection(LinkedList::new));// 当前审批人的索引int indexOf = linkedList.indexOf(userId);if (1 == type) {//前置加签if (indexOf == 0) {linkedList.addFirst(addUserId);} else {linkedList.add(indexOf, addUserId);}} else if (2 == type) {//后置加签if (linkedList.size() - 1 == indexOf) {linkedList.addLast(addUserId);} else {linkedList.add(indexOf + 1, addUserId);}} else {if (indexOf == 0) {linkedList.addFirst(addUserId);} else {linkedList.add(indexOf, addUserId);}}// 人员变量Map<String, Object> vars = new HashMap<String, Object>(1);if (auditMethod == 3) {// 顺序签处理int indexOfto = linkedList.indexOf(userId);List<String> userIds = new ArrayList<>();for (int i = 0; i < linkedList.size(); i++) {String id = linkedList.get(i);if (1 == type) {// 前置if ((indexOfto - 1) <= i) {userIds.add(id);}} else if (2 == type) {// 后置if (indexOfto <= i) {userIds.add(id);}} else {userIds.add(id);}}res.set("userIds", userIds);vars.put("assigneeList_" + activityId, userIds);} else {res.set("userIds", linkedList);vars.put("assigneeList_" + activityId, linkedList.stream().collect(Collectors.toList()));}// 获取当前环节实例ProcessInstanceModificationBuilder processInstanceModificationBuilder = runtimeService.createProcessInstanceModification(processInstanceId);Set<String> activityIdSet = new HashSet<>();taskService.createTaskQuery().processInstanceId(processInstanceId).active().list().forEach(taskQuery -> {String activityId1 = taskQuery.getTaskDefinitionKey();if(activityIdSet.add(activityId1)){// 关闭当前多实例活动任务节点processInstanceModificationBuilder.cancelAllForActivity(activityId1);}});// 启动当前多实例活动任务节点processInstanceModificationBuilder.startBeforeActivity(childActivityInstance.getActivityId())// 局部变量.setVariablesLocal(vars).execute();return res;}// 8、todo 我的待办-待审核public JSONObject pending(JSONObject params) {String userId = params.get("userId", String.class);Integer pageIndex = params.get("pageIndex", Integer.class);Integer pageSize = params.get("pageSize", Integer.class);int firstResult = (pageIndex - 1) * pageSize ;int maxResults = pageSize;//查询待办List<Task> list = taskService.createTaskQuery().taskAssignee(userId).listPage(firstResult, maxResults);long count = taskService.createTaskQuery().taskAssignee(userId).count();// 封装结果集JSONObject res = new JSONObject();res.set("list", list);res.set("pageCount", count);return res;}// 8、todo 我的已办public JSONObject done(JSONObject params) {String userId = params.get("userId", String.class);Integer pageIndex = params.get("pageIndex", Integer.class);Integer pageSize = params.get("pageSize", Integer.class);int firstResult = (pageIndex - 1) * pageSize ;int maxResults = pageSize;List<HistoricTaskInstance> historicTaskInstances = historyService.createHistoricTaskInstanceQuery().taskAssignee(userId).finished().listPage(firstResult, maxResults);long count = historyService.createHistoricTaskInstanceQuery().taskAssignee(userId).finished().count();JSONObject res = new JSONObject();res.set("list", historicTaskInstances);res.set("pageCount", count);return res;}// 9、todo 作废public JSONObject invalid(JSONObject params) {// 流程到了最后一个审批节点可以作废，流程实例和业务数据关系表状态变更，业务数据回滚，// 获取变量String processInstanceId = params.get("processInstanceId", String.class);String userId = params.get("userId", String.class);String comment = params.get("comment", String.class);//作废意见JSONObject res = new JSONObject();return res;}// 10、todo 转阅public JSONObject forward(JSONObject params) {JSONObject res = new JSONObject();return res;}// 11、撤回public JSONObject withdraw(JSONObject params) {// 获取变量String taskId = params.get("taskId", String.class);String processInstanceId = params.get("processInstanceId", String.class);String userId = params.get("userId", String.class);// 获取当前任务，未办理任务idHistoricTaskInstance currTask = historyService.createHistoricTaskInstanceQuery().taskId(taskId).singleResult();if (ObjectUtil.isNull(currTask)) {log.error("没有查询到审批任务");JSONObject res = new JSONObject();res.set("msg", "没有查询到审批任务");return res;}// 撤回审批意见taskService.createComment(taskId, processInstanceId, "发起人撤回");// 退回至起点申请人ProcessInstanceModificationBuilder processInstanceModificationBuilder = runtimeService.createProcessInstanceModification(processInstanceId);Set<String> activityIdSet = new HashSet<>();taskService.createTaskQuery().processInstanceId(processInstanceId).active().list().forEach(taskQuery -> {String activityId = taskQuery.getTaskDefinitionKey();if(activityIdSet.add(activityId)){processInstanceModificationBuilder.cancelAllForActivity(activityId);}});processInstanceModificationBuilder.setAnnotation("撤回")// 启动申请人节点.startBeforeActivity(currTask.getTaskDefinitionKey()).execute();// 结果集封装JSONObject res = new JSONObject();return res;}// 12、todo 催办public JSONObject urge(JSONObject params) {JSONObject res = new JSONObject();return res;}// 13、todo 获取历史节点public JSONObject listHistoricalNode(JSONObject params) {
//        // 新建一个有序不重复集合
//        LinkedHashSet linkedHashSet = new LinkedHashSet();获取当前的任务节点
//        String activeTask = "Activity_0lj34xv";
//        String backTask = "";
//        historyService.createHistoricTaskInstanceQuery().processInstanceId(processInstanceId).orderByHistoricTaskInstanceEndTime().asc().list().stream().forEach(historicTaskInstance -> {
//            linkedHashSet.add(historicTaskInstance.getTaskDefinitionKey());
//        });
//        if(linkedHashSet.size() == 0){
//            return ;
//        }遍历到当前的任务节点后,取上一次遍历的值
//        Iterator<String> iterator = linkedHashSet.iterator();
//        while(iterator.hasNext()){
//            String nowTask = iterator.next();
//            if(StrUtil.equals(nowTask,activeTask)){
//                return backTask;
//            }
//            backTask = nowTask;
//        }
//        backTask.toString();JSONObject res = new JSONObject();return res;}// 14、重新启动流程实例public JSONObject relaunch(Map<String, Object> params) {String initiator = (String) params.get("initiator");String processDefinitionId = (String) params.get("processDefinitionId");String processInstanceId = (String) params.get("processInstanceId");String businessKey = (String) params.get("businessKey");Map<String, Object> variables = (Map<String, Object>) params.get("variables");// 覆盖所有变量runtimeService.setVariables(processInstanceId, variables);// 跳过发起人节点，进行审批List<Task> list = taskService.createTaskQuery().taskAssignee(initiator).taskName("发起人").processInstanceId(processInstanceId).list();if (CollUtil.isNotEmpty(list)) {taskService.complete(list.get(0).getId());}// 结果集封装JSONObject res = new JSONObject();return  res;}
}
package com.oa.business.flow.utils.camunda.constant;
/*** @author HeZeMin* @className CamundaE* @description 流程引擎枚举类* @date 2022/4/8 18:02*/
public enum CamundaEnum {PROCESS("Process_"),EVENT("Event_"),ACTIVITY("Activity_"),GATEWAY("Gateway_"),TASK("Task_");private final String name;private CamundaEnum(String name) {this.name = name;}public String getName() {return name;}
}

 Camunda监听器实现

package com.oa.business.flow.utils.camunda.listener;import cn.hutool.core.collection.CollUtil;
import cn.hutool.json.JSONUtil;
import com.oa.dubbo.api.flow.service.act.ActHiProcinstService;
import lombok.extern.slf4j.Slf4j;
import org.camunda.bpm.engine.TaskService;
import org.camunda.bpm.engine.delegate.DelegateTask;
import org.camunda.bpm.engine.delegate.TaskListener;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;import java.util.List;/*** Description:抄送人服务* @Author HeZeMin* @Date 2022年04月20日 17:24*/
@Slf4j
@Component("CopyListener")
public class CopyListener implements TaskListener {@AutowiredTaskService taskService;@AutowiredActHiProcinstService actHiProcinstService;/***基本思路 - 监听器实现* 可以通过给抄送节点添加监听器，进而在通过自己的业务实现数据库消息表的添加。* 拿到当前task的一些信息，查询要抄送的人的信息，然后通过Spring IOC中拿到的service进行相应的业务逻辑添加（消息表新增），然后对该节点进行一个通过。*/@Overridepublic void notify(DelegateTask delegateTask) {String eventName = delegateTask.getEventName();String taskId = delegateTask.getId();String processInstanceId = delegateTask.getProcessInstanceId();String taskDefinitionKey = delegateTask.getTaskDefinitionKey();List<String> userIdList = (List<String>) delegateTask.getVariable("assigneeList_" + taskDefinitionKey);if("create".equals(eventName)){// 抄送人  业务处理log.info("create===========抄送人逻辑开始");// 更新流程步骤的审批状态if (CollUtil.isNotEmpty(userIdList)) {// 保存待阅// 给抄送人发站内信和提醒}// 该抄送任务完成taskService.complete(delegateTask.getId());} else if("assigment".equals(eventName)){log.info("assigment===========流程部署");} else if("complete".equals(eventName)){log.info("complete===========抄送人逻辑完成");} else if("delete".equals(eventName)){log.info("delete===========流程结束");}log.info("delegateTask.getAssignee() = " + delegateTask.getAssignee());log.info("delegateTask.getId() = " + delegateTask.getId());log.info("taskDefinitionKey = " + taskDefinitionKey);log.info("variables = " + JSONUtil.toJsonStr(delegateTask.getVariables()));log.info("userIdList = " + JSONUtil.toJsonStr(userIdList));log.info("=--------------------------------=");}}
package com.oa.business.flow.utils.camunda.listener;import com.oa.dubbo.api.flow.service.act.ActHiProcinstService;
import lombok.extern.slf4j.Slf4j;
import org.camunda.bpm.engine.TaskService;
import org.camunda.bpm.engine.delegate.DelegateExecution;
import org.camunda.bpm.engine.delegate.ExecutionListener;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;/*** Description:流程结束服务* @Author HeZeMin* @Date 2022年04月20日 17:24*/
@Slf4j
@Component("EndEventListener")
public class EndEventListener implements ExecutionListener {@AutowiredTaskService taskService;@AutowiredActHiProcinstService actHiProcinstService;/*** 基本思路 - 监听器实现* 可以通过给结束节点添加监听器，进而在通过自己的业务实现数据库消息表的添加。* 拿到流程实例信息，变更业务表状态为已通过，或者同步申请数据到业务表*/@Overridepublic void notify(DelegateExecution execution) throws Exception {log.info("===========流程结束了==========");String eventName = execution.getEventName();String businessKey = execution.getProcessBusinessKey();String processDefinitionId = execution.getProcessDefinitionId();String processInstanceId = execution.getProcessInstanceId();String initiator = (String) execution.getVariable("initiator");String tableName = "";if("start".equals(eventName)){log.info("start===========流程启动");// 给发起人发消息}else if("end".equals(eventName)){// 修改流程实例关系状态为 已完成log.info("end===========流程结束");}log.info("delegateTask.getId() = " + execution.getId());log.info("tableName = " + tableName);log.info("processDefinitionId = " + processDefinitionId);log.info("processInstanceId = " + processInstanceId);log.info("businessKey = " + businessKey);log.info("=--------------------------------=");}}
package com.oa.business.flow.utils.camunda.listener;import com.oa.dubbo.api.flow.service.act.ActHiProcinstService;
import lombok.extern.slf4j.Slf4j;
import org.camunda.bpm.engine.TaskService;
import org.camunda.bpm.engine.delegate.DelegateTask;
import org.camunda.bpm.engine.delegate.TaskListener;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;/*** Description:审批和执行人的站内信和提醒 监听器* @Author HeZeMin* @Date 2022年06月17日 9:39*/
@Slf4j
@Component("TaskMessageListener")
public class TaskMessageListener implements TaskListener {@AutowiredTaskService taskService;@AutowiredActHiProcinstService actHiProcinstService;/***基本思路 - 监听器实现* 可以通过给抄送节点添加监听器，进而在通过自己的业务实现数据库消息表的添加。* 拿到当前task的一些信息，查询要抄送的人的信息，然后通过Spring IOC中拿到的service进行相应的业务逻辑添加（消息表新增），然后对该节点进行一个通过。*/@Overridepublic void notify(DelegateTask delegateTask) {String eventName = delegateTask.getEventName();String taskId = delegateTask.getId();String taskDefinitionKey = delegateTask.getTaskDefinitionKey();String processInstanceId = delegateTask.getProcessInstanceId();if(TaskListener.EVENTNAME_CREATE.equals(eventName)){log.info("create===========审批节点开始");// 更新流程步骤的审批状态// 给待审核人发提醒}else if("assigment".equals(eventName)){log.info("assigment===========流程部署");}else if("complete".equals(eventName)){log.info("complete===========流程完成");// 更新流程步骤的审批状态}else if("delete".equals(eventName)){log.info("delete===========流程结束");}log.info("delegateTask.getAssignee() = " + delegateTask.getAssignee());log.info("taskId = " + taskId);log.info("taskDefinitionKey = " + taskDefinitionKey);log.info("eventName = " + eventName);log.info("processInstanceId = " + processInstanceId);log.info("=--------------------------------=");}}

Camunda框架的49张表结构

/*Navicat Premium Data TransferSource Server         : 222.175.63.26-oa-prodSource Server Type    : MySQLSource Server Version : 80024Source Host           : 222.175.63.26:13307Source Schema         : oa_cloud_masterTarget Server Type    : MySQLTarget Server Version : 80024File Encoding         : 65001Date: 21/10/2022 10:17:48
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for act_ge_bytearray
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_bytearray`;
CREATE TABLE `act_ge_bytearray`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部署ID',`BYTES_` longblob NULL COMMENT '字节内容',`GENERATED_` tinyint NULL DEFAULT NULL COMMENT '是否系统生成（0用户创建,null系统生成）',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`TYPE_` int NULL DEFAULT NULL COMMENT '类型',`CREATE_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例根ID',`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',PRIMARY KEY (`ID_`) USING BTREE,INDEX `DEPLOYMENT_ID_`(`DEPLOYMENT_ID_`) USING BTREE,INDEX `ROOT_PROC_INST_ID_`(`ROOT_PROC_INST_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程通用数据/流程引擎二进制数据表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ge_property
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_property`;
CREATE TABLE `act_ge_property`  (`NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',`VALUE_` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值',`REV_` int NULL DEFAULT NULL COMMENT '版本',PRIMARY KEY (`NAME_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程通用数据/流程引擎属性配置表【初始化】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ge_schema_log
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_schema_log`;
CREATE TABLE `act_ge_schema_log`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`TIMESTAMP_` datetime(0) NULL DEFAULT NULL COMMENT '时间戳',`VERSION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本',PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程通用数据/数据库脚本执行日志表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_actinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_actinst`;
CREATE TABLE `act_hi_actinst`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`PARENT_ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父节点实例ID',`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义KEY',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '流程定义ID',`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例根ID',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '流程实例ID',`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '执行实例ID',`ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '节点ID',`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务ID',`CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '调用外部的流程实例ID',`CALL_CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '调用外部的案例实例ID',`ACT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点名称',`ACT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '节点类型',`ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '办理人',`START_TIME_` datetime(0) NOT NULL COMMENT '开始时间',`END_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',`DURATION_` bigint NULL DEFAULT NULL COMMENT '耗时',`ACT_INST_STATE_` int NULL DEFAULT NULL COMMENT '活动实例状态',`SEQUENCE_COUNTER_` bigint NULL DEFAULT NULL COMMENT '序列计数器',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',PRIMARY KEY (`ID_`) USING BTREE,INDEX `ACT_ID_`(`ACT_ID_`) USING BTREE,INDEX `TASK_ID_`(`TASK_ID_`) USING BTREE,INDEX `EXECUTION_ID_`(`EXECUTION_ID_`) USING BTREE,INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,INDEX `ROOT_PROC_INST_ID_`(`ROOT_PROC_INST_ID_`) USING BTREE,INDEX `PROC_DEF_ID_`(`PROC_DEF_ID_`) USING BTREE,INDEX `PROC_DEF_KEY_`(`PROC_DEF_KEY_`) USING BTREE,INDEX `PARENT_ACT_INST_ID_`(`PARENT_ACT_INST_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的活动实例表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_attachment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_attachment`;
CREATE TABLE `act_hi_attachment`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NULL DEFAULT NULL,`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`URL_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CONTENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CREATE_TIME_` datetime(0) NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的流程附件表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_batch
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_batch`;
CREATE TABLE `act_hi_batch`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TOTAL_JOBS_` int NULL DEFAULT NULL,`JOBS_PER_SEED_` int NULL DEFAULT NULL,`INVOCATIONS_PER_JOB_` int NULL DEFAULT NULL,`SEED_JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`MONITOR_JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`BATCH_JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CREATE_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`START_TIME_` datetime(0) NOT NULL,`END_TIME_` datetime(0) NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的批处理记录表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_caseactinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_caseactinst`;
CREATE TABLE `act_hi_caseactinst`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`PARENT_ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`CASE_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CALL_CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_ACT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_ACT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CREATE_TIME_` datetime(0) NOT NULL,`END_TIME_` datetime(0) NULL DEFAULT NULL,`DURATION_` bigint NULL DEFAULT NULL,`STATE_` int NULL DEFAULT NULL,`REQUIRED_` bit(1) NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的CMMN活动实例表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_caseinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_caseinst`;
CREATE TABLE `act_hi_caseinst`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`CREATE_TIME_` datetime(0) NOT NULL,`CLOSE_TIME_` datetime(0) NULL DEFAULT NULL,`DURATION_` bigint NULL DEFAULT NULL,`STATE_` int NULL DEFAULT NULL,`CREATE_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SUPER_CASE_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SUPER_PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的CMMN实例表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_comment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_comment`;
CREATE TABLE `act_hi_comment`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型（event事件、comment意见）',`TIME_` datetime(0) NOT NULL COMMENT '时间',`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理人',`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务ID',`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例跟ID',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`ACTION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行为类型',`MESSAGE_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '基本内容',`FULL_MSG_` longblob NULL COMMENT '全部内容',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '移除时间',PRIMARY KEY (`ID_`) USING BTREE,INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,INDEX `TASK_ID_`(`TASK_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的流程审批意见表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_dec_in
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_dec_in`;
CREATE TABLE `act_hi_dec_in`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`DEC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`CLAUSE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CLAUSE_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`VAR_TYPE_` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DOUBLE_` double NULL DEFAULT NULL,`LONG_` bigint NULL DEFAULT NULL,`TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CREATE_TIME_` datetime(0) NULL DEFAULT NULL,`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的DMN变量输入表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_dec_out
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_dec_out`;
CREATE TABLE `act_hi_dec_out`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`DEC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`CLAUSE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CLAUSE_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`RULE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`RULE_ORDER_` int NULL DEFAULT NULL,`VAR_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`VAR_TYPE_` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DOUBLE_` double NULL DEFAULT NULL,`LONG_` bigint NULL DEFAULT NULL,`TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CREATE_TIME_` datetime(0) NULL DEFAULT NULL,`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的DMN变量输出表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_decinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_decinst`;
CREATE TABLE `act_hi_decinst`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`DEC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`DEC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`DEC_DEF_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`EVAL_TIME_` datetime(0) NOT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,`COLLECT_VALUE_` double NULL DEFAULT NULL,`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ROOT_DEC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DEC_REQ_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DEC_REQ_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的DMN实例表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_detail
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_detail`;
CREATE TABLE `act_hi_detail`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型',`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义KEY',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例根ID',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程执行ID',`CASE_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例定义KEY',`CASE_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例定义ID',`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例实例ID',`CASE_EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例执行ID',`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务ID',`ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点实例ID',`VAR_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程变量记录ID',`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',`VAR_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变量类型',`REV_` int NULL DEFAULT NULL COMMENT '版本',`TIME_` datetime(0) NOT NULL COMMENT '时间戳',`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二进制数据对应ID',`DOUBLE_` double NULL DEFAULT NULL COMMENT 'double类型值',`LONG_` bigint NULL DEFAULT NULL COMMENT 'long类型值',`TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本类型值',`TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本类型值2',`SEQUENCE_COUNTER_` bigint NULL DEFAULT NULL COMMENT '序列计数器',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`OPERATION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '移除时间',`INITIAL_` bit(1) NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE,INDEX `PROC_DEF_KEY_`(`PROC_DEF_KEY_`) USING BTREE,INDEX `PROC_DEF_ID_`(`PROC_DEF_ID_`) USING BTREE,INDEX `ROOT_PROC_INST_ID_`(`ROOT_PROC_INST_ID_`) USING BTREE,INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,INDEX `EXECUTION_ID_`(`EXECUTION_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的流程运行时变量详情记录表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_ext_task_log
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_ext_task_log`;
CREATE TABLE `act_hi_ext_task_log`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`TIMESTAMP_` timestamp(0) NOT NULL,`EXT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`RETRIES_` int NULL DEFAULT NULL,`TOPIC_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`WORKER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PRIORITY_` bigint NOT NULL DEFAULT 0,`ERROR_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ERROR_DETAILS_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`STATE_` int NULL DEFAULT NULL,`REV_` int NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的流程任务消息执行表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_identitylink`;
CREATE TABLE `act_hi_identitylink`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`TIMESTAMP_` timestamp(0) NOT NULL COMMENT '时间戳',`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',`GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户组ID',`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务ID',`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例根ID',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`OPERATION_TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作类型',`ASSIGNER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分配者ID',`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义KEY',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '移除时间',PRIMARY KEY (`ID_`) USING BTREE,INDEX `TASK_ID_`(`TASK_ID_`) USING BTREE,INDEX `ROOT_PROC_INST_ID_`(`ROOT_PROC_INST_ID_`) USING BTREE,INDEX `PROC_DEF_ID_`(`PROC_DEF_ID_`) USING BTREE,INDEX `PROC_DEF_KEY_`(`PROC_DEF_KEY_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的流程运行过程中用户关系【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_incident
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_incident`;
CREATE TABLE `act_hi_incident`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CREATE_TIME_` timestamp(0) NOT NULL,`END_TIME_` timestamp(0) NULL DEFAULT NULL,`INCIDENT_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`INCIDENT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`ACTIVITY_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`FAILED_ACTIVITY_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CAUSE_INCIDENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ROOT_CAUSE_INCIDENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`HISTORY_CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`INCIDENT_STATE_` int NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ANNOTATION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的流程异常事件记录表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_job_log
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_job_log`;
CREATE TABLE `act_hi_job_log`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`TIMESTAMP_` datetime(0) NOT NULL,`JOB_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`JOB_DUEDATE_` datetime(0) NULL DEFAULT NULL,`JOB_RETRIES_` int NULL DEFAULT NULL,`JOB_PRIORITY_` bigint NOT NULL DEFAULT 0,`JOB_EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`JOB_EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`JOB_STATE_` int NULL DEFAULT NULL,`JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`JOB_DEF_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`JOB_DEF_CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`FAILED_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROCESS_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROCESS_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SEQUENCE_COUNTER_` bigint NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`HOSTNAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的流程作业记录表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_op_log
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_op_log`;
CREATE TABLE `act_hi_op_log`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`JOB_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`BATCH_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TIMESTAMP_` timestamp(0) NOT NULL,`OPERATION_TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`OPERATION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ENTITY_TYPE_` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROPERTY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ORG_VALUE_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`NEW_VALUE_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,`CATEGORY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`EXTERNAL_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ANNOTATION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE,INDEX `DEPLOYMENT_ID_`(`DEPLOYMENT_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/操作历史日志【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_procinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_procinst`;
CREATE TABLE `act_hi_procinst`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '流程实例ID',`BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务KEY',`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义KEY',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '流程定义ID',`START_TIME_` datetime(0) NOT NULL COMMENT '开始时间',`END_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '移除时间',`DURATION_` bigint NULL DEFAULT NULL COMMENT '耗时',`START_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '启动人ID',`START_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '启动节点ID',`END_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结束节点ID',`SUPER_PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父流程实例ID',`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例根ID',`SUPER_CASE_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父案例实例ID',`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例实例ID',`DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除原因',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`STATE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',PRIMARY KEY (`ID_`) USING BTREE,INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,INDEX `BUSINESS_KEY_`(`BUSINESS_KEY_`) USING BTREE,INDEX `PROC_DEF_KEY_`(`PROC_DEF_KEY_`) USING BTREE,INDEX `PROC_DEF_ID_`(`PROC_DEF_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的流程实例【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_taskinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_taskinst`;
CREATE TABLE `act_hi_taskinst`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务定义KEY',`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义KEY',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例根ID',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程执行ID',`CASE_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例定义KEY',`CASE_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例定义ID',`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例实例ID',`CASE_EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例执行ID',`ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点实例ID',`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',`PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父任务ID',`DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',`OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委托人ID',`ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '办理人ID',`START_TIME_` datetime(0) NOT NULL COMMENT '开始时间',`END_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',`DURATION_` bigint NULL DEFAULT NULL COMMENT '耗时',`DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除原因',`PRIORITY_` int NULL DEFAULT NULL COMMENT '优先级',`DUE_DATE_` datetime(0) NULL DEFAULT NULL COMMENT '超时时间',`FOLLOW_UP_DATE_` datetime(0) NULL DEFAULT NULL COMMENT '跟踪时间',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '移除时间',PRIMARY KEY (`ID_`) USING BTREE,INDEX `TASK_DEF_KEY_`(`TASK_DEF_KEY_`) USING BTREE,INDEX `PROC_DEF_KEY_`(`PROC_DEF_KEY_`) USING BTREE,INDEX `PROC_DEF_ID_`(`PROC_DEF_ID_`) USING BTREE,INDEX `ROOT_PROC_INST_ID_`(`ROOT_PROC_INST_ID_`) USING BTREE,INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,INDEX `EXECUTION_ID_`(`EXECUTION_ID_`) USING BTREE,INDEX `ACT_INST_ID_`(`ACT_INST_ID_`) USING BTREE,INDEX `ASSIGNEE_`(`ASSIGNEE_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的任务实例【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_hi_varinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_varinst`;
CREATE TABLE `act_hi_varinst`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义KEY',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例根ID',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程执行ID',`ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点实例ID',`CASE_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例定义KEY',`CASE_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例定义ID',`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例实例ID',`CASE_EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例执行ID',`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务ID',`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',`VAR_TYPE_` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变量类型',`CREATE_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',`REV_` int NULL DEFAULT NULL COMMENT '版本',`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二进制数据ID',`DOUBLE_` double NULL DEFAULT NULL COMMENT 'double类型值',`LONG_` bigint NULL DEFAULT NULL COMMENT 'long类型值',`TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本类型值',`TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本类型值2',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`STATE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '移除时间',PRIMARY KEY (`ID_`) USING BTREE,INDEX `PROC_DEF_KEY_`(`PROC_DEF_KEY_`) USING BTREE,INDEX `PROC_DEF_ID_`(`PROC_DEF_ID_`) USING BTREE,INDEX `ROOT_PROC_INST_ID_`(`ROOT_PROC_INST_ID_`) USING BTREE,INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,INDEX `EXECUTION_ID_`(`EXECUTION_ID_`) USING BTREE,INDEX `TASK_ID_`(`TASK_ID_`) USING BTREE,INDEX `ACT_INST_ID_`(`ACT_INST_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程历史记录/历史的流程变量记录表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_id_group
-- ----------------------------
DROP TABLE IF EXISTS `act_id_group`;
CREATE TABLE `act_id_group`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组名称',`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组类型（SYSTEM系统、WORKFLOW业务）',PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织用户信息/群组信息表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_id_info
-- ----------------------------
DROP TABLE IF EXISTS `act_id_info`;
CREATE TABLE `act_id_info`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NULL DEFAULT NULL,`USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`VALUE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PASSWORD_` longblob NULL,`PARENT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织用户信息/用户扩展信息表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_id_membership
-- ----------------------------
DROP TABLE IF EXISTS `act_id_membership`;
CREATE TABLE `act_id_membership`  (`USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户ID',`GROUP_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '组ID',PRIMARY KEY (`USER_ID_`, `GROUP_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织用户信息/用户群组关系表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_id_tenant
-- ----------------------------
DROP TABLE IF EXISTS `act_id_tenant`;
CREATE TABLE `act_id_tenant`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NULL DEFAULT NULL,`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织用户信息/租户信息表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_id_tenant_member
-- ----------------------------
DROP TABLE IF EXISTS `act_id_tenant_member`;
CREATE TABLE `act_id_tenant_member`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`GROUP_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织用户信息/用户租户关系表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_id_user
-- ----------------------------
DROP TABLE IF EXISTS `act_id_user`;
CREATE TABLE `act_id_user`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`FIRST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓',`LAST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名',`EMAIL_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮件',`PWD_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',`SALT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '盐值',`LOCK_EXP_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '锁定过期时间',`ATTEMPTS_` int NULL DEFAULT NULL COMMENT '尝试次数',`PICTURE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片ID',PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织用户信息/用户信息表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_re_camformdef
-- ----------------------------
DROP TABLE IF EXISTS `act_re_camformdef`;
CREATE TABLE `act_re_camformdef`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NULL DEFAULT NULL,`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`VERSION_` int NOT NULL,`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程资源存储/' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_re_case_def
-- ----------------------------
DROP TABLE IF EXISTS `act_re_case_def`;
CREATE TABLE `act_re_case_def`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NULL DEFAULT NULL,`CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`VERSION_` int NOT NULL,`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`HISTORY_TTL_` int NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程资源存储/CMMN案例管理模型定义表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_re_decision_def
-- ----------------------------
DROP TABLE IF EXISTS `act_re_decision_def`;
CREATE TABLE `act_re_decision_def`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NULL DEFAULT NULL,`CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`VERSION_` int NOT NULL,`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DEC_REQ_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DEC_REQ_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`HISTORY_TTL_` int NULL DEFAULT NULL,`VERSION_TAG_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程资源存储/DMN决策模型定义表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_re_decision_req_def
-- ----------------------------
DROP TABLE IF EXISTS `act_re_decision_req_def`;
CREATE TABLE `act_re_decision_req_def`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NULL DEFAULT NULL,`CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`VERSION_` int NOT NULL,`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程资源存储/决策需求定义表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_re_deployment
-- ----------------------------
DROP TABLE IF EXISTS `act_re_deployment`;
CREATE TABLE `act_re_deployment`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程名称',`DEPLOY_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '部署时间',`SOURCE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程资源存储/流程部署表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_re_procdef
-- ----------------------------
DROP TABLE IF EXISTS `act_re_procdef`;
CREATE TABLE `act_re_procdef`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义的Namespace分类',`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义名称',`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '流程定义KEY',`VERSION_` int NOT NULL COMMENT '流程定义版本号',`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部署ID',`RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源名称',`DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'DGRM资源名称',`HAS_START_FORM_KEY_` tinyint NULL DEFAULT NULL COMMENT '是否有启动表单',`SUSPENSION_STATE_` int NULL DEFAULT NULL COMMENT '流程挂起',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`VERSION_TAG_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本标签',`HISTORY_TTL_` int NULL DEFAULT NULL,`STARTABLE_` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否是可启动流程',PRIMARY KEY (`ID_`) USING BTREE,INDEX `KEY_`(`KEY_`) USING BTREE,INDEX `DEPLOYMENT_ID_`(`DEPLOYMENT_ID_`) USING BTREE,INDEX `VERSION_`(`VERSION_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程资源存储/BPMN流程模型定义表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_authorization
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_authorization`;
CREATE TABLE `act_ru_authorization`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NOT NULL,`TYPE_` int NOT NULL,`GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`RESOURCE_TYPE_` int NOT NULL,`RESOURCE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PERMS_` int NULL DEFAULT NULL,`REMOVAL_TIME_` datetime(0) NULL DEFAULT NULL,`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程运行时收取表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_batch
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_batch`;
CREATE TABLE `act_ru_batch`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NOT NULL,`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TOTAL_JOBS_` int NULL DEFAULT NULL,`JOBS_CREATED_` int NULL DEFAULT NULL,`JOBS_PER_SEED_` int NULL DEFAULT NULL,`INVOCATIONS_PER_JOB_` int NULL DEFAULT NULL,`SEED_JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`BATCH_JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`MONITOR_JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SUSPENSION_STATE_` int NULL DEFAULT NULL,`CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CREATE_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程执行批处理表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_case_execution
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_case_execution`;
CREATE TABLE `act_ru_case_execution`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NULL DEFAULT NULL,`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SUPER_CASE_EXEC_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SUPER_EXEC_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PARENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PREV_STATE_` int NULL DEFAULT NULL,`CURRENT_STATE_` int NULL DEFAULT NULL,`REQUIRED_` bit(1) NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/CMMN案例运行执行表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_case_sentry_part
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_case_sentry_part`;
CREATE TABLE `act_ru_case_sentry_part`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NULL DEFAULT NULL,`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_EXEC_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SENTRY_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SOURCE_CASE_EXEC_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`STANDARD_EVENT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SOURCE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`VARIABLE_EVENT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`VARIABLE_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`SATISFIED_` bit(1) NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/CMMN案例运行时哨兵部分表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_event_subscr
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_event_subscr`;
CREATE TABLE `act_ru_event_subscr`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`EVENT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '事件类型',`EVENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '事件名称',`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行ID',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`ACTIVITY_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点ID',`CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置',`CREATED_` datetime(0) NOT NULL COMMENT '创建时间',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程事件订阅表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_execution
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_execution`;
CREATE TABLE `act_ru_execution`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例根ID',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务KEY',`PARENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程父实例ID',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`SUPER_EXEC_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父流程实例对应的执行',`SUPER_CASE_EXEC_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父案例实例对应的执行',`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例实例ID',`ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点ID',`ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点实例ID',`IS_ACTIVE_` tinyint NULL DEFAULT NULL COMMENT '是否激活',`IS_CONCURRENT_` tinyint NULL DEFAULT NULL COMMENT '是否并行',`IS_SCOPE_` tinyint NULL DEFAULT NULL COMMENT '是否多实例范围',`IS_EVENT_SCOPE_` tinyint NULL DEFAULT NULL COMMENT '是否事件多实例范围',`SUSPENSION_STATE_` int NULL DEFAULT NULL COMMENT '挂起状态',`CACHED_ENT_STATE_` int NULL DEFAULT NULL COMMENT '缓存状态',`SEQUENCE_COUNTER_` bigint NULL DEFAULT NULL COMMENT '序列计数器',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',PRIMARY KEY (`ID_`) USING BTREE,INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,INDEX `BUSINESS_KEY_`(`BUSINESS_KEY_`) USING BTREE,INDEX `PROC_DEF_ID_`(`PROC_DEF_ID_`) USING BTREE,INDEX `ACT_INST_ID_`(`ACT_INST_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/BPMN流程运行时记录表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_ext_task
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_ext_task`;
CREATE TABLE `act_ru_ext_task`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NOT NULL,`WORKER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TOPIC_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`RETRIES_` int NULL DEFAULT NULL,`ERROR_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ERROR_DETAILS_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`LOCK_EXP_TIME_` datetime(0) NULL DEFAULT NULL,`SUSPENSION_STATE_` int NULL DEFAULT NULL,`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PRIORITY_` bigint NOT NULL DEFAULT 0,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程任务消息执行表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_filter
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_filter`;
CREATE TABLE `act_ru_filter`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REV_` int NOT NULL,`RESOURCE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`QUERY_` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`PROPERTIES_` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程定义查询配置表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_identitylink`;
CREATE TABLE `act_ru_identitylink`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户组ID',`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务ID',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/运行时流程人员表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_incident
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_incident`;
CREATE TABLE `act_ru_incident`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NOT NULL COMMENT '版本',`INCIDENT_TIMESTAMP_` datetime(0) NOT NULL COMMENT '事件时间戳',`INCIDENT_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '事件信息',`INCIDENT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '事件类型',`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程执行ID',`ACTIVITY_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点ID',`FAILED_ACTIVITY_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`CAUSE_INCIDENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '事件原因ID',`ROOT_CAUSE_INCIDENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '事件原因根ID',`CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '事件配置',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JOB定义ID',`ANNOTATION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/运行时异常事件表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_job`;
CREATE TABLE `act_ru_job`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型',`LOCK_EXP_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '锁定过期时间',`LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '锁定用户',`EXCLUSIVE_` bit(1) NULL DEFAULT NULL COMMENT '独占标识',`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行ID',`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`PROCESS_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`PROCESS_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义KEY',`RETRIES_` int NULL DEFAULT NULL COMMENT '重试次数',`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '异常堆栈ID',`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '异常信息',`FAILED_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`DUEDATE_` datetime(0) NULL DEFAULT NULL COMMENT '截止时间',`REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '重复',`REPEAT_OFFSET_` bigint NULL DEFAULT 0,`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理类型',`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理配置',`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部署ID',`SUSPENSION_STATE_` int NOT NULL DEFAULT 1 COMMENT '挂起状态',`JOB_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作业定义ID',`PRIORITY_` bigint NOT NULL DEFAULT 0 COMMENT '作业优先级',`SEQUENCE_COUNTER_` bigint NULL DEFAULT NULL COMMENT '序列计数器',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`CREATE_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程运行时作业表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_jobdef
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_jobdef`;
CREATE TABLE `act_ru_jobdef`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`PROC_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义KEY',`ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点ID',`JOB_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'JOB类型',`JOB_CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JOB配置',`SUSPENSION_STATE_` int NULL DEFAULT NULL COMMENT '挂起状态',`JOB_PRIORITY_` bigint NULL DEFAULT NULL COMMENT '优先级',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程作业定义表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_meter_log
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_meter_log`;
CREATE TABLE `act_ru_meter_log`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`REPORTER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`VALUE_` bigint NULL DEFAULT NULL,`TIMESTAMP_` datetime(0) NULL DEFAULT NULL,`MILLISECONDS_` bigint NULL DEFAULT 0,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程运行时度量日志表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_task
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_task`;
CREATE TABLE `act_ru_task`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程执行ID',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义ID',`CASE_EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例执行ID',`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例实例ID',`CASE_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例定义ID',`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',`PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父任务ID',`DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',`TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务定义KEY',`OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委托人',`ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '办理人',`DELEGATION_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委托状态',`PRIORITY_` int NULL DEFAULT NULL COMMENT '优先级',`CREATE_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',`DUE_DATE_` datetime(0) NULL DEFAULT NULL COMMENT '截止时间',`FOLLOW_UP_DATE_` datetime(0) NULL DEFAULT NULL COMMENT '跟踪时间',`SUSPENSION_STATE_` int NULL DEFAULT NULL COMMENT '挂起状态',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',PRIMARY KEY (`ID_`) USING BTREE,INDEX `EXECUTION_ID_`(`EXECUTION_ID_`) USING BTREE,INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,INDEX `PROC_DEF_ID_`(`PROC_DEF_ID_`) USING BTREE,INDEX `PARENT_TASK_ID_`(`PARENT_TASK_ID_`) USING BTREE,INDEX `ASSIGNEE_`(`ASSIGNEE_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程运行时任务表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_task_meter_log
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_task_meter_log`;
CREATE TABLE `act_ru_task_meter_log`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`ASSIGNEE_HASH_` bigint NULL DEFAULT NULL,`TIMESTAMP_` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/运行时task度量日志表【常用】' ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for act_ru_variable
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_variable`;
CREATE TABLE `act_ru_variable`  (`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',`REV_` int NULL DEFAULT NULL COMMENT '版本',`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '变量类型',`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '变量名称',`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程执行ID',`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例ID',`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`CASE_EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例执行ID',`CASE_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '案例实例ID',`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务ID',`BATCH_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二进制内容ID',`DOUBLE_` double NULL DEFAULT NULL COMMENT 'DOUBLE类型值',`LONG_` bigint NULL DEFAULT NULL COMMENT 'LONG类型值',`TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本值',`TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本值２',`VAR_SCOPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '变量范围',`SEQUENCE_COUNTER_` bigint NULL DEFAULT NULL COMMENT '序列计数器',`IS_CONCURRENT_LOCAL_` tinyint NULL DEFAULT NULL COMMENT '是否并发',`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',PRIMARY KEY (`ID_`) USING BTREE,INDEX `PROC_DEF_ID_`(`PROC_DEF_ID_`) USING BTREE,INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,INDEX `EXECUTION_ID_`(`EXECUTION_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程运行时/流程运行时变量表【常用】' ROW_FORMAT = Dynamic;SET FOREIGN_KEY_CHECKS = 1;


http://chatgpt.dhexx.cn/article/TYS3QQrj.shtml

相关文章

小飞鱼通达二开 OA工作流打印次数统计控制程序（图文）

小飞鱼通达二开 OA工作流打印次数统计控制程序（图文）

每个工作流工作打印了多少次了&#xff0c;在OA里不知道&#xff0c;如何能够控制呢&#xff0c;今天小飞鱼带给大家的就是这个工作量打印次数统计控制程序&#xff0c;使用起来是不是会方便很多。 可以查询打印日志明细。 打印页面上多了一个打印按钮和流水号、打印次数的信息…
阅读更多...
通达OA工作流-表单设计

通达OA工作流-表单设计

第1章 什么是工作流 1.1 工作流的用途 随着企业管理信息化进程的不断深入&#xff0c;协同应用软件的概念已深入人心&#xff0c;而工作流系统正是协同应用软件的核心。通过应用 IT 技术来规范工作流程、提高工作的执行效率和准确度、使企业运营更加高效、规范、稳健&…
阅读更多...
通达OA 工作流执行出现的异常现象处理（图文）

通达OA 工作流执行出现的异常现象处理（图文）

一个朋友用的工作流&#xff0c;突然说这里面多了很多人不应该看到这个流程的&#xff0c;就是在查询工作时&#xff0c;最上面多了一个“查阅信息”项&#xff0c;然后最下面多了很多人查询的记录。这个项目是从哪里来的呢&#xff1f;普通的流程倒也无所谓了&#xff0c;而有…
阅读更多...
小飞鱼通达二开 通达OA工作流表单标题下拉列表字体样式设置（图文）

小飞鱼通达二开 通达OA工作流表单标题下拉列表字体样式设置（图文）

今天的一个流程表单里使用了下拉列表框&#xff0c;如下图&#xff1a; 在设计视图和预览时都没有问题&#xff0c;只是在流程查询时显示的不正常。表单上的样式对于变成文字后的数据不再起作用。 小飞鱼经过研究&#xff0c;发现原来是系统在数据浏览页面时加载了其他的样式文…
阅读更多...
OA工作流概述

OA工作流概述

本文转自&#xff1a;http://www.cnblogs.com/cuihongyu3503319/archive/2007/10/15/924378.html 一、工作流是什么&#xff1f; 工作流是从英文单词work flow中直译过来的。用在OA系统中最直白的意思就是日常工作中相对固定的流程计算机化。 例如&#xff1a;空管站发文的流程…
阅读更多...
通达oa工作流升级 操作说明

通达oa工作流升级 操作说明

通达oa工作流升级 操作说明 升级程序下载链接: https://pan.baidu.com/s/1SL_7qePn7c6pWnCR16VG2A 提取码: s6dx 1.停止其他用户访问oa 2.备份oa数据 3.对工作流数据进行归档 注意&#xff1a;如果有父子流程&#xff0c;其中子流程办结&#xff0c;父流程没有办结的情…
阅读更多...
OA工作流-Activiti(一)

OA工作流-Activiti(一)

OA工作流-Activiti(一) 一、工作流定义 工作流&#xff1a;一系列相互衔接、自动进行的业务活动或任务。 OA工作流&#xff1a;建立于网络办公自动化基础上的事务行政审批&#xff0c;业务申请审批、公文、信息等的网上流转。它主要解决的是“使在多个参与者之间按照某种预定义…
阅读更多...
4、telnet

4、telnet

0x01、题目&#xff1a;telnet 0x02、WP 1、右键链接&#xff0c;点击新建标签页打开&#xff0c;保存附件1.zip 2、解压后得到一个名为networking.pcap的流量包&#xff0c;很明显题目是telnet&#xff0c;众所周知&#xff0c;telnet是明文的传输数据&#xff0c;我们用wir…
阅读更多...
嵌入式linux开发，启用busybox的telnetd服务

嵌入式linux开发，启用busybox的telnetd服务

Telnet协议是TCP/IP协议族中的一员&#xff0c;是Internet远程登录服务的标准协议和主要方式。它为用户提供了在本地计算机上完成远程主机工作的能力。在终端使用者的电脑上使用telnet程序&#xff0c;用它连接到服务器。终端使用者可以在telnet程序中输入命令&#xff0c;这些…
阅读更多...
Telnet| 开启Telnet服务(Linux,Windows)

Telnet| 开启Telnet服务(Linux,Windows)

文章目录 简介Linux下安装开启Telnet服务Windows10中开启Telnet服务 简介 Telnet协议是一种应用层协议&#xff0c;使用于互联网及局域网中&#xff0c;使用虚拟终端机的形式&#xff0c;提供双向、以文字字符串为主的命令行接口交互功能。属于TCP/IP协议族的其中之一&#xf…
阅读更多...
linux开发板开启telnetd

linux开发板开启telnetd

需求:linux开发板开启telnetd, pc上SercureCRT连接; 前提: 开发板和pc能ping通; 1. 开发板端 在脚本 /etc/init.d/rcS中添加; mount -t devpts devpts /dev/pts telnetd -l /bin/login 2. sercureCRT端 协议选择Telnet,主机名为开发板端ip地址;点击连接即可; 参考: 开发板…
阅读更多...
telnet与http

telnet与http

本博客基于【win10开启了telnet】【未开启自行百度开启即可】 遇到的问题&#xff1a; 一开始用 winr 打开了cmd, 然后输入telnet进入了telnet, 再然后输入了telnet www.hit.edu.cn 80(本以为会连接上&#xff0c;结果出现【无效指令。需要帮助…】 //还以为是我telnet出了问题…
阅读更多...
TELNET协议

TELNET协议

参考链接&#xff1a;https://blog.csdn.net/luo104660577/article/details/47001105 1、Telnet协议的目的是提供一个相对通用的&#xff0c;双向的&#xff0c;面向八位字节的通信方法&#xff0c;允许界面终端设备和面向终端的过程能通过一个标准过程进行互相交互。应用Teln…
阅读更多...
【telnet的用法】

【telnet的用法】

1.首先需要本地pc支持telent.找到程序中心&#xff0c;打开windows功能&#xff0c;勾选telnet客户端。 telnet命令&#xff1a; 3.执行telnt命令&#xff1a; telnet 33.44.55.66 5001即可&#xff0c;注意端口号这里不加 &#xff1a; 如果联网了可以不用telnet&#xff…
阅读更多...
Telnet 使用

Telnet 使用

01简介 telnet是一个实用的远程连接命令&#xff0c;采用的是TCP/IP协议。它为用户提供了在本地计算机上完成远程主机工作的能力&#xff0c;在终端使用者的电脑上使用telnet程序&#xff0c;用它连接到服务器。终端使用者可以在telnet程序中输入命令&#xff0c;这些命令会在服…
阅读更多...
Telnet详解

Telnet详解

------ Oracle中文开发者社区 ------ 如果你想要学习编程,关注本博客,持续获得技术支持,持续获得技术咨询
阅读更多...
计算机开启telnet服务,Telnet服务是什么？如何开启Telnet服务

计算机开启telnet服务,Telnet服务是什么？如何开启Telnet服务

Telnet服务是什么&#xff1f;Telnet服务器软件是我们最常用的远程登录服务器软件&#xff0c;是一种典型的客户机/服务器模型的服务&#xff0c;它应用Telnet协议来工作。那么&#xff0c;什么是Telnet协议&#xff1f;它都具备哪些特点呢&#xff1f; Telnet是位于OSI模型的第…
阅读更多...
telnet介绍

telnet介绍

介绍 Telnet 是一个应用程序&#xff0c;用于连接到远程主机的命令行终端界面。网络和系统管理员使用此应用程序来配置和管理服务器、路由器、交换机等网络设备。此应用程序基于面向连接的传输控制协议 (TCP)。默认情况下&#xff0c;telnet 服务器在端口 23 上侦听来自客户端…
阅读更多...
telnet-server

telnet-server

telnet-server 安装 安装 yum install telnet telnet-server xinetd -y # 开启服务 systemctl start telnet.socket systemctl start xinetd# 设置开机自启 systemctl enable xinetd.service systemctl enable telnet.socket
阅读更多...
Telnet使用

Telnet使用

一.简介 Telnet是常用的远程登录手段&#xff0c;有两种操作模式&#xff1a;Telnet命令模式和Telnet会话模式。连接到Telnet服务器后&#xff0c;Telnet客户端会自动进入Telnet会话模式&#xff0c;此模式最常见。在会话模式下&#xff0c;所有击键将通过网络发送到Telnet服务…
阅读更多...
推荐文章

Copyright @ 2022~2023