activiti数据库表名说明

爱被打了一巴掌 2023-07-04 04:54 43阅读 0赞

## 1、表名含义 ##

Activiti的所有数据库表都以ACT\_开头。第二部分是说明表用途的两字符标示符。服务API的命名也大略符合这个规则。

*  ACT\_RE\_\*: 'RE’代表 repository 。带有这个前缀的表包含“静态”信息，例如流程定义与流程资源（图片、规则等）。
 *  ACT\_RU\_\*: 'RU’代表 runtime 。这些表存储运行时信息，例如流程实例（process instance）、用户任务（user task）、变量（variable）、作业（job）等。Activiti只在流程实例运行中保存运行时数据，并在流程实例结束时删除记录。这样保证运行时表小和快。
 *  ACT\_ID\_\*: 'ID’代表 identity 。这些表包含身份信息，例如用户、组等。
 *  ACT\_HI\_\*: 'HI’代表 history 。这些表存储历史数据，例如已完成的流程实例、变量、任务等。
 *  ACT\_GE\_\*: 通用数据。用于不同场景下。

## 2、Activiti数据表清单: ##

<table> 
 <thead> 
  <tr> 
   <th>表分类</th> 
   <th>表名</th> 
   <th>解释</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>一般数据</td> 
   <td>ACT_GE_BYTEARRAY</td> 
   <td>通用的流程定义和流程资源（png图）</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_GE_PROPERTY</td> 
   <td>系统相关属性</td> 
  </tr> 
  <tr> 
   <td>流程历史记录</td> 
   <td>ACT_HI_ACTINST</td> 
   <td>历史的流程实例</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_HI_ATTACHMENT</td> 
   <td>历史的流程附件</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_HI_COMMENT</td> 
   <td>历史的说明性信息</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_HI_DETAIL</td> 
   <td>历史的流程运行中的细节信息</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_HI_IDENTITYLINK</td> 
   <td>历史的流程运行过程中用户关系</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_HI_PROCINST</td> 
   <td>历史的流程实例</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_HI_TASKINST</td> 
   <td>历史的任务实例</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_HI_VARINST</td> 
   <td>历史的流程运行中的变量信息</td> 
  </tr> 
  <tr> 
   <td>用户用户组表</td> 
   <td>ACT_ID_GROUP</td> 
   <td>身份信息-组信息</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_ID_INFO</td> 
   <td>身份信息-组信息</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_ID_MEMBERSHIP</td> 
   <td>身份信息-用户和组关系的中间表</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_ID_USER</td> 
   <td>身份信息-用户信息</td> 
  </tr> 
  <tr> 
   <td>流程定义表</td> 
   <td>ACT_RE_DEPLOYMENT</td> 
   <td>部署单元信息</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_RE_MODEL</td> 
   <td>模型信息</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_RE_PROCDEF</td> 
   <td>已部署的流程定义</td> 
  </tr> 
  <tr> 
   <td>运行实例表</td> 
   <td>ACT_RU_EVENT_SUBSCR</td> 
   <td>运行时事件</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_RU_EXECUTION</td> 
   <td>运行时流程执行实例</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_RU_IDENTITYLINK</td> 
   <td>运行时用户关系信息</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_RU_JOB</td> 
   <td>运行时作业</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_RU_TASK</td> 
   <td>运行时任务</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>ACT_RU_VARIABLE</td> 
   <td>运行时变量表</td> 
  </tr> 
 </tbody> 
</table>

## 3、表结构及说明 ##

### 3.1 ACT\_GE\_BYTEARRAY ###

用来保存部署文件的大文本数据。

保存流程定义图片和xml、Serializable(序列化)的变量,即保存所有二进制数据，特别注意类路径部署时候，不要把svn等隐藏文件或者其他与流程无关的文件也一起部署到该表中，会造成一些错误（可能导致流程定义无法删除）。

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>主键ID，资源文件编号，自增长</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>版本号</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>Version</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>部署的文件名称，</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>mail.bpmn、mail.png 、mail.bpmn20.xml</td> 
  </tr> 
  <tr> 
   <td>DEPLOYMENT_ID_</td> 
   <td>来自于父表ACT_RE_DEPLOYMENT的主键</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>部署的ID</td> 
  </tr> 
  <tr> 
   <td>BYTES_</td> 
   <td>大文本类型，存储文本字节流</td> 
   <td>LONGBLOB</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>GENERATED_</td> 
   <td>是否是引擎生成。</td> 
   <td>TINYINT(4)</td> 
   <td>是</td> 
   <td>0为用户生成;1为Activiti生成</td> 
  </tr> 
 </tbody> 
</table>

### 3.2 **ACT\_GE\_PROPERTY** ###

属性数据表。存储这个流程引擎级别的数据。

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>NAME_</td> 
   <td>属性名称</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>schema.version;schema.history;next.dbid</td> 
  </tr> 
  <tr> 
   <td>VALUE_</td> 
   <td>属性值</td> 
   <td>VARCHAR(300)</td> 
   <td>是</td> 
   <td>create(6.0.0.4)</td> 
  </tr> 
  <tr> 
   <td>REV_INT</td> 
   <td>版本号</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 3.3 ACT\_HI\_ACTINST ###

历史活动信息。这里记录流程流转过的所有节点，与HI\_TASKINST不同的是，taskinst只记录usertask内容。

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>PROC_DEF_ID_</td> 
   <td>流程定义ID</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>EXECUTION_ID_</td> 
   <td>流程执行ID</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>节点定义ID</td> 
  </tr> 
  <tr> 
   <td>ACT_ID_</td> 
   <td>活动ID</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>TASK_ID_</td> 
   <td>任务ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>任务实例ID 其他节点类型实例ID在这里为空</td> 
  </tr> 
  <tr> 
   <td>CALL_PROC_INST_ID_</td> 
   <td>请求流程实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>调用外部流程的流程实例ID'</td> 
  </tr> 
  <tr> 
   <td>ACT_NAME_</td> 
   <td>活动名称</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>节点定义名称</td> 
  </tr> 
  <tr> 
   <td>ACT_TYPE_</td> 
   <td>活动类型</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
   <td>如startEvent、userTask</td> 
  </tr> 
  <tr> 
   <td>ASSIGNEE_</td> 
   <td>代理人员</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>节点签收人</td> 
  </tr> 
  <tr> 
   <td>START_TIME_</td> 
   <td>开始时间</td> 
   <td>DATETIME</td> 
   <td>&nbsp;</td> 
   <td>2013/9/15 11:30</td> 
  </tr> 
  <tr> 
   <td>END_TIME_</td> 
   <td>结束时间</td> 
   <td>DATETIME</td> 
   <td>是</td> 
   <td>2013/9/15 11:30</td> 
  </tr> 
  <tr> 
   <td>DURATION_</td> 
   <td>时长，耗时</td> 
   <td>BIGINT(20)</td> 
   <td>是</td> 
   <td>毫秒值</td> 
  </tr> 
 </tbody> 
</table>

### 3.4 ACT\_HI\_ATTACHMENT ###

附件信息

### 3.5 ACT\_HI\_COMMENT ###

历史审批意见表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>长度</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>主键ID</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>TYPE_</td> 
   <td>意见记录类型，为comment时，为处理意见</td> 
   <td>VARCHAR(255)</td> 
   <td>255</td> 
   <td>是</td> 
   <td>类型：event（事件）</td> 
  </tr> 
  <tr> 
   <td>comment（意见）</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>TIME_</td> 
   <td>记录时间</td> 
   <td>DATETIME</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>填写时间</td> 
  </tr> 
  <tr> 
   <td>USER_ID_</td> 
   <td>用户Id</td> 
   <td>VARCHAR(255)</td> 
   <td>255</td> 
   <td>是</td> 
   <td>填写人</td> 
  </tr> 
  <tr> 
   <td>TASK_ID_</td> 
   <td>任务Id</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>是</td> 
   <td>节点实例ID</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例Id</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>是</td> 
   <td>流程实例ID</td> 
  </tr> 
  <tr> 
   <td>ACTION_</td> 
   <td>行为类型。</td> 
   <td>VARCHAR(255)</td> 
   <td>255</td> 
   <td>是</td> 
   <td>值为下列内容中的一种：　　　　AddUserLink、DeleteUserLink、AddGroupLink、DeleteGroupLink、AddComment、AddAttachment、DeleteAttachment</td> 
  </tr> 
  <tr> 
   <td>MESSAGE_</td> 
   <td>处理意见</td> 
   <td>VARCHAR(4000)</td> 
   <td>4000</td> 
   <td>是</td> 
   <td>用于存放流程产生的信息，比如审批意见</td> 
  </tr> 
  <tr> 
   <td>FULL_MSG_</td> 
   <td>全部消息</td> 
   <td>LONGBLOB</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 3.6 ACT\_HI\_DETAIL ###

历史详情表：流程中产生的变量详细，包括控制流程流转的变量，业务表单中填写的流程需要用到的变量等。

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>长度</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>&nbsp;</td> 
   <td>主键</td> 
  </tr> 
  <tr> 
   <td>TYPE_</td> 
   <td>数据类型</td> 
   <td>VARCHAR(255)</td> 
   <td>255</td> 
   <td>&nbsp;</td> 
   <td>类型: FormProperty, //表单 VariableUpdate //参数</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>是</td> 
   <td>流程实例ID</td> 
  </tr> 
  <tr> 
   <td>EXECUTION_ID_</td> 
   <td>执行实例Id</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>是</td> 
   <td>执行实例ID</td> 
  </tr> 
  <tr> 
   <td>TASK_ID_</td> 
   <td>任务Id</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>是</td> 
   <td>任务实例ID</td> 
  </tr> 
  <tr> 
   <td>ACT_INST_ID_</td> 
   <td>活动实例Id</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>是</td> 
   <td>ACT_HI_ACTINST表的ID</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>名称</td> 
   <td>VARCHAR(255)</td> 
   <td>255</td> 
   <td>&nbsp;</td> 
   <td>名称</td> 
  </tr> 
  <tr> 
   <td>VAR_TYPE_</td> 
   <td>变量类型</td> 
   <td>VARCHAR(255)</td> 
   <td>255</td> 
   <td>是</td> 
   <td>jpa-entity、boolean、bytes、serializable、 CustomVariableType、date、double、integer、long、null、short、string</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>REV_</td> 
   <td>INT(11)</td> 
   <td>11</td> 
   <td>是</td> 
   <td>Version</td> 
  </tr> 
  <tr> 
   <td>TIME_</td> 
   <td>创建时间</td> 
   <td>DATETIME</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>创建时间</td> 
  </tr> 
  <tr> 
   <td>BYTEARRAY_ID_</td> 
   <td>字节数组Id</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>是</td> 
   <td>ACT_GE_BYTEARRAY表的ID</td> 
  </tr> 
  <tr> 
   <td>DOUBLE_</td> 
   <td>DOUBLE_</td> 
   <td>DOUBLE</td> 
   <td>&nbsp;</td> 
   <td>是</td> 
   <td>存储变量类型为Double</td> 
  </tr> 
  <tr> 
   <td>LONG_</td> 
   <td>LONG_</td> 
   <td>BIGINT(20)</td> 
   <td>20</td> 
   <td>是</td> 
   <td>存储变量类型为long</td> 
  </tr> 
  <tr> 
   <td>TEXT_</td> 
   <td>值</td> 
   <td>VARCHAR(4000)</td> 
   <td>4000</td> 
   <td>是</td> 
   <td>存储变量值类型为String</td> 
  </tr> 
  <tr> 
   <td>TEXT2_</td> 
   <td>值2</td> 
   <td>VARCHAR(4000)</td> 
   <td>4000</td> 
   <td>是</td> 
   <td>此处存储的是JPA持久化对象时，才会有值。此值为对象ID</td> 
  </tr> 
 </tbody> 
</table>

### 3.7 ACT\_HI\_IDENTITYLINK ###

任务参与者数据表。主要存储历史节点参与者的信息。

### 3.8 ACT\_HI\_PROCINST ###

历史流程实例信息

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>BUSINESS_KEY_</td> 
   <td>业务Key</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>PROC_DEF_ID_</td> 
   <td>流程定义Id</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>START_TIME_</td> 
   <td>开始时间</td> 
   <td>DATETIME</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>END_TIME_</td> 
   <td>结束时间</td> 
   <td>DATETIME</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>DURATION_</td> 
   <td>时长</td> 
   <td>BIGINT(20)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>START_USER_ID_</td> 
   <td>发起人员Id</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>START_ACT_ID_</td> 
   <td>开始节点</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>END_ACT_ID_</td> 
   <td>结束节点</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>SUPER_PROCESS_INSTANCE_ID_</td> 
   <td>超级流程实例Id</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>DELETE_REASON_</td> 
   <td>删除理由</td> 
   <td>VARCHAR(4000)</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 3.9 ACT\_HI\_TASKINST ###

历史任务流程实例信息

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>主键ID</td> 
  </tr> 
  <tr> 
   <td>PROC_DEF_ID_</td> 
   <td>流程定义Id</td> 
   <td>VARCHAR(64)</td> 
   <td>流程定义ID</td> 
  </tr> 
  <tr> 
   <td>TASK_DEF_KEY_</td> 
   <td>任务定义Key</td> 
   <td>VARCHAR(255)</td> 
   <td>节点定义ID</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>流程实例ID</td> 
  </tr> 
  <tr> 
   <td>EXECUTION_ID_</td> 
   <td>执行ID</td> 
   <td>VARCHAR(64)</td> 
   <td>执行实例ID</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>名称</td> 
   <td>VARCHAR(255)</td> 
   <td>名称</td> 
  </tr> 
  <tr> 
   <td>PARENT_TASK_ID_</td> 
   <td>父任务iD</td> 
   <td>VARCHAR(64)</td> 
   <td>父节点实例ID</td> 
  </tr> 
  <tr> 
   <td>DESCRIPTION_</td> 
   <td>描述</td> 
   <td>VARCHAR(4000)</td> 
   <td>描述</td> 
  </tr> 
  <tr> 
   <td>OWNER_</td> 
   <td>实际签收人 任务的拥有者</td> 
   <td>VARCHAR(255)</td> 
   <td>签收人（默认为空，只有在委托时才有值）</td> 
  </tr> 
  <tr> 
   <td>ASSIGNEE_</td> 
   <td>代理人</td> 
   <td>VARCHAR(255)</td> 
   <td>签收人或被委托</td> 
  </tr> 
  <tr> 
   <td>START_TIME_</td> 
   <td>开始时间</td> 
   <td>DATETIME</td> 
   <td>开始时间</td> 
  </tr> 
  <tr> 
   <td>CLAIM_TIME_</td> 
   <td>提醒时间</td> 
   <td>DATETIME</td> 
   <td>提醒时间</td> 
  </tr> 
  <tr> 
   <td>END_TIME_</td> 
   <td>结束时间</td> 
   <td>DATETIME</td> 
   <td>结束时间</td> 
  </tr> 
  <tr> 
   <td>DURATION_</td> 
   <td>时长</td> 
   <td>BIGINT(20)</td> 
   <td>耗时</td> 
  </tr> 
  <tr> 
   <td>DELETE_REASON_</td> 
   <td>删除理由</td> 
   <td>VARCHAR(4000)</td> 
   <td>删除原因(completed,deleted)</td> 
  </tr> 
  <tr> 
   <td>PRIORITY_</td> 
   <td>优先级</td> 
   <td>INT(11)</td> 
   <td>优先级别</td> 
  </tr> 
  <tr> 
   <td>DUE_DATE_</td> 
   <td>应完成时间</td> 
   <td>DATETIME</td> 
   <td>过期时间，表明任务应在多长时间内完成</td> 
  </tr> 
  <tr> 
   <td>FORM_KEY_</td> 
   <td>表单key</td> 
   <td>VARCHAR(255)</td> 
   <td>desinger节点定义的form_key属性</td> 
  </tr> 
 </tbody> 
</table>

### 3.10 ACT\_HI\_VARINST ###

历史变量信息

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>ID_</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>流程实例ID</td> 
  </tr> 
  <tr> 
   <td>EXECUTION_ID_</td> 
   <td>执行ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>执行实例ID</td> 
  </tr> 
  <tr> 
   <td>TASK_ID_</td> 
   <td>任务Id</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>任务实例ID</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>名称</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
   <td>参数名称(英文)</td> 
  </tr> 
  <tr> 
   <td>VAR_TYPE_</td> 
   <td>变量类型</td> 
   <td>VARCHAR(100)</td> 
   <td>是</td> 
   <td>参见VAR_TYPE_类型说明</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>REV_</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>Version</td> 
  </tr> 
  <tr> 
   <td>BYTEARRAY_ID_</td> 
   <td>字节数组ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>ACT_GE_BYTEARRAY表的主键</td> 
  </tr> 
  <tr> 
   <td>DOUBLE_</td> 
   <td>DOUBLE_</td> 
   <td>DOUBLE</td> 
   <td>&nbsp;</td> 
   <td>存储DoubleType类型的数据</td> 
  </tr> 
  <tr> 
   <td>LONG_</td> 
   <td>LONG_</td> 
   <td>BIGINT(20)</td> 
   <td>是</td> 
   <td>存储LongType类型的数据</td> 
  </tr> 
  <tr> 
   <td>TEXT_</td> 
   <td>TEXT_</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>存储变量值类型为String，如此处存储持久化对象时，值jpa对象的class</td> 
  </tr> 
  <tr> 
   <td>TEXT2_</td> 
   <td>TEXT2_</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>此处存储的是JPA持久化对象时，才会有值。此值为对象ID</td> 
  </tr> 
 </tbody> 
</table>

### 3.11 ACT\_ID\_GROUP ###

用户组表,用来存储用户组信息。

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>用户组ID</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>版本号</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>用户组描述信息</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>TYPE_</td> 
   <td>用户组类型</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 3.12 ACT\_ID\_INFO ###

用户扩展信息表。

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>64</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>版本号</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>USER_ID_</td> 
   <td>用户ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>TYPE_</td> 
   <td>类型</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>KEY_</td> 
   <td>formINPut名称</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>VALUE_</td> 
   <td>值</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>PASSWORD_</td> 
   <td>密码</td> 
   <td>LONGBLOB</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>PARENT_ID_</td> 
   <td>父节点</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 3.13 ACT\_ID\_MEMBERSHIP ###

用来保存用户的分组信息

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>USER_ID_</td> 
   <td>用户Id</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>GROUP_ID_</td> 
   <td>用户组Id</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 3.14 ACT\_ID\_USER ###

用户信息表

### 3.15 ACT\_RE\_DEPLOYMENT ###

部署信息表， 用来存储部署时需要持久化保存下来的信息

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>部署编号，自增长</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>部署包的名称</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>CATEGORY_</td> 
   <td>类型</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>TENANT_ID_</td> 
   <td>租户</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>多租户通常是在软件需要为多个不同组织服务时产生的概念</td> 
  </tr> 
  <tr> 
   <td>DEPLOY_TIME_</td> 
   <td>部署时间</td> 
   <td>TIMESTAMP</td> 
   <td>&nbsp;</td> 
   <td>CURRENT_TIMESTAMP</td> 
  </tr> 
 </tbody> 
</table>

### 3.16 ACT\_RE\_MODEL ###

流程设计模型表，创建流程的设计模型时，保存在该数据表中。

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>ID_</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>INT(11)</td> 
   <td>11</td> 
   <td>是</td> 
   <td>版本号</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>模型的名称：</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>名称</td> 
  </tr> 
  <tr> 
   <td>KEY_</td> 
   <td>模型的关键字，流程引擎用到。</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>分类，例如：</td> 
  </tr> 
  <tr> 
   <td>CATEGORY_</td> 
   <td>类型，用户自己对流程模型的分类。</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>分类</td> 
  </tr> 
  <tr> 
   <td>CREATE_TIME_</td> 
   <td>创建时间</td> 
   <td>TIMESTAMP</td> 
   <td>是</td> 
   <td>创建时间</td> 
  </tr> 
  <tr> 
   <td>LAST_UPDATE_TIME_</td> 
   <td>最后修改时间</td> 
   <td>TIMESTAMP</td> 
   <td>是</td> 
   <td>最新修改时间</td> 
  </tr> 
  <tr> 
   <td>VERSION_</td> 
   <td>版本，从1开始。</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>版本</td> 
  </tr> 
  <tr> 
   <td>META_INFO_</td> 
   <td>数据源信息，比如：</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>以json格式保存流程定义的信息</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>DEPLOYMENT_ID_</td> 
   <td>部署ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>部署ID</td> 
  </tr> 
  <tr> 
   <td>EDITOR_SOURCE_VALUE_ID_</td> 
   <td>编辑源值ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>是 ACT_GE_BYTEARRAY 表中的ID_值。</td> 
  </tr> 
  <tr> 
   <td>EDITOR_SOURCE_EXTRA_VALUE_ID_</td> 
   <td>编辑源额外值ID（外键ACT_GE_BYTEARRAY ）</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>是 ACT_GE_BYTEARRAY 表中的ID_值。</td> 
  </tr> 
  <tr> 
   <td>TENANT_ID_</td> 
   <td>租户</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 3.17 ACT\_RE\_PROCDEF ###

流程解析表，解析成功了，在该表保存一条记录。业务流程定义数据表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>流程ID，由“流程编号：流程版本号：自增长ID”组成</td> 
   <td>VARCHAR(64)</td> 
   <td>ID_</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>版本号</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>乐观锁</td> 
  </tr> 
  <tr> 
   <td>CATEGORY_</td> 
   <td>流程命名空间（该编号就是流程文件targetNamespace的属性值）</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>流程定义的Namespace就是类别</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>流程名称（该编号就是流程文件process元素的name属性值）</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>名称</td> 
  </tr> 
  <tr> 
   <td>KEY_</td> 
   <td>流程编号（该编号就是流程文件process元素的id属性值）</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
   <td>流程定义ID</td> 
  </tr> 
  <tr> 
   <td>VERSION_</td> 
   <td>流程版本号（由程序控制，新增即为1，修改后依次加1来完成的）</td> 
   <td>INT(11)</td> 
   <td>&nbsp;</td> 
   <td>版本</td> 
  </tr> 
  <tr> 
   <td>DEPLOYMENT_ID_</td> 
   <td>部署编号</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>部署表ID</td> 
  </tr> 
  <tr> 
   <td>RESOURCE_NAME_</td> 
   <td>资源文件名称</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>流程bpmn文件名称</td> 
  </tr> 
  <tr> 
   <td>DGRM_RESOURCE_NAME_</td> 
   <td>图片资源文件名称</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>png流程图片名称</td> 
  </tr> 
  <tr> 
   <td>DESCRIPTION_</td> 
   <td>描述信息</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>描述</td> 
  </tr> 
  <tr> 
   <td>HAS_START_FORM_KEY_</td> 
   <td>是否从key启动</td> 
   <td>TINYINT(4)</td> 
   <td>是</td> 
   <td>start节点是否存在formKey。0否 1是</td> 
  </tr> 
  <tr> 
   <td>SUSPENSION_STATE_</td> 
   <td>是否挂起</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>1激活 2挂起</td> 
  </tr> 
 </tbody> 
</table>

### 3.18 ACT\_RU\_EVENT\_SUBSCR ###

运行时事件

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>版本号</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>EVENT_TYPE_</td> 
   <td>事件类型</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>EVENT_NAME_</td> 
   <td>事件名称</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>EXECUTION_ID_</td> 
   <td>流程执行ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>ACTIVITY_ID_</td> 
   <td>活动ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>CONFIGURATION_</td> 
   <td>配置信息</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>CREATED_</td> 
   <td>创建时间</td> 
   <td>TIMESTAMP</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 3.19 ACT\_RU\_EXECUTION ###

运行时流程执行实例，我的代办任务查询表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>ID_</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>版本号</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>乐观锁</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例编号</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>流程实例ID</td> 
  </tr> 
  <tr> 
   <td>BUSINESS_KEY_</td> 
   <td>业务编号</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>业务主键ID</td> 
  </tr> 
  <tr> 
   <td>PARENT_ID_</td> 
   <td>父执行流程</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>父节点实例ID</td> 
  </tr> 
  <tr> 
   <td>PROC_DEF_ID_</td> 
   <td>流程定义Id</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>流程定义ID</td> 
  </tr> 
  <tr> 
   <td>SUPER_EXEC_</td> 
   <td>&nbsp;</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>ACT_ID_</td> 
   <td>实例id</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>节点实例ID即ACT_HI_ACTINST中ID</td> 
  </tr> 
  <tr> 
   <td>IS_ACTIVE_</td> 
   <td>激活状态</td> 
   <td>TINYINT(4)</td> 
   <td>是</td> 
   <td>是否存活</td> 
  </tr> 
  <tr> 
   <td>IS_CONCURRENT_</td> 
   <td>并发状态</td> 
   <td>TINYINT(4)</td> 
   <td>是</td> 
   <td>是否为并行(true/false）</td> 
  </tr> 
  <tr> 
   <td>IS_SCOPE_</td> 
   <td>&nbsp;</td> 
   <td>TINYINT(4)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>IS_EVENT_SCOPE_</td> 
   <td>&nbsp;</td> 
   <td>TINYINT(4)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>SUSPENSION_STATE_</td> 
   <td>暂停状态_</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>挂起状态 1激活 2挂起</td> 
  </tr> 
  <tr> 
   <td>CACHED_ENT_STATE_</td> 
   <td>缓存结束状态_</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 3.20 ACT\_RU\_IDENTITYLINK ###

身份联系,主要存储当前节点参与者的信息,任务参与者数据表。

### 3.21 ACT\_RU\_JOB ###

运行时定时任务数据表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>版本</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>版本</td> 
  </tr> 
  <tr> 
   <td>TYPE_</td> 
   <td>类型</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
   <td>类型</td> 
  </tr> 
  <tr> 
   <td>LOCK_EXP_TIME_</td> 
   <td>锁定释放时间</td> 
   <td>TIMESTAMP</td> 
   <td>是</td> 
   <td>锁定释放时间</td> 
  </tr> 
  <tr> 
   <td>LOCK_OWNER_</td> 
   <td>挂起者</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>挂起者</td> 
  </tr> 
  <tr> 
   <td>EXCLUSIVE_</td> 
   <td>&nbsp;</td> 
   <td>TINYINT(1)</td> 
   <td>是</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>EXECUTION_ID_</td> 
   <td>执行实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>执行实例ID</td> 
  </tr> 
  <tr> 
   <td>PROCESS_INSTANCE_ID_</td> 
   <td>流程实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>流程实例ID</td> 
  </tr> 
  <tr> 
   <td>PROC_DEF_ID_</td> 
   <td>流程定义ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>流程定义ID</td> 
  </tr> 
  <tr> 
   <td>RETRIES_</td> 
   <td>重试次数</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>重试次数</td> 
  </tr> 
  <tr> 
   <td>EXCEPTION_STACK_ID_</td> 
   <td>异常信息ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>异常信息ID</td> 
  </tr> 
  <tr> 
   <td>EXCEPTION_MSG_</td> 
   <td>异常信息</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>异常信息</td> 
  </tr> 
  <tr> 
   <td>DUEDATE_</td> 
   <td>到期时间</td> 
   <td>TIMESTAMP</td> 
   <td>是</td> 
   <td>到期时间</td> 
  </tr> 
  <tr> 
   <td>REPEAT_</td> 
   <td>重复</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>重复</td> 
  </tr> 
  <tr> 
   <td>HANDLER_TYPE_</td> 
   <td>处理类型</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>处理类型</td> 
  </tr> 
  <tr> 
   <td>HANDLER_CFG_</td> 
   <td>标识</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>标识</td> 
  </tr> 
 </tbody> 
</table>

### 3.22 ACT\_RU\_TASK ###

运行时任务数据表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>取值说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>ID_</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>版本号</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>版本号</td> 
  </tr> 
  <tr> 
   <td>EXECUTION_ID_</td> 
   <td>实例id（外键EXECUTION_ID_）</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>执行实例ID</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例ID（外键PROC_INST_ID_）</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>流程实例ID</td> 
  </tr> 
  <tr> 
   <td>PROC_DEF_ID_</td> 
   <td>流程定义ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>流程定义ID</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>任务名称</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>节点定义名称</td> 
  </tr> 
  <tr> 
   <td>PARENT_TASK_ID_</td> 
   <td>父节任务ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>父节点实例ID</td> 
  </tr> 
  <tr> 
   <td>DESCRIPTION_</td> 
   <td>任务描述</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>节点定义描述</td> 
  </tr> 
  <tr> 
   <td>TASK_DEF_KEY_</td> 
   <td>任务定义key</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>任务定义的ID</td> 
  </tr> 
  <tr> 
   <td>OWNER_</td> 
   <td>所属人(老板)</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>拥有者（一般情况下为空，只有在委托时才有值）</td> 
  </tr> 
  <tr> 
   <td>ASSIGNEE_</td> 
   <td>代理人员</td> 
   <td>VARCHAR(255)</td> 
   <td>是</td> 
   <td>签收人或委托人</td> 
  </tr> 
  <tr> 
   <td>DELEGATION_</td> 
   <td>委托类型</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>委托类型，DelegationState分为两种：PENDING，RESOLVED。如无委托则为空</td> 
  </tr> 
  <tr> 
   <td>PRIORITY_</td> 
   <td>优先权</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>优先级别，默认为：50</td> 
  </tr> 
  <tr> 
   <td>CREATE_TIME_</td> 
   <td>创建时间</td> 
   <td>TIMESTAMP</td> 
   <td>&nbsp;</td> 
   <td>创建时间，CURRENT_TIMESTAMP</td> 
  </tr> 
  <tr> 
   <td>DUE_DATE_</td> 
   <td>执行时间</td> 
   <td>DATETIME</td> 
   <td>是</td> 
   <td>耗时</td> 
  </tr> 
  <tr> 
   <td>SUSPENSION_STATE_</td> 
   <td>暂停状态</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>1代表激活 2代表挂起</td> 
  </tr> 
 </tbody> 
</table>

### 3.23 ACT\_RU\_VARIABLE ###

运行时流程变量数据表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>字段描述</th> 
   <th>数据类型</th> 
   <th>可空</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID_</td> 
   <td>ID_</td> 
   <td>VARCHAR(64)</td> 
   <td>&nbsp;</td> 
   <td>主键标识</td> 
  </tr> 
  <tr> 
   <td>REV_</td> 
   <td>版本号</td> 
   <td>INT(11)</td> 
   <td>是</td> 
   <td>乐观锁</td> 
  </tr> 
  <tr> 
   <td>TYPE</td> 
   <td>编码类型</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
   <td>参见VAR_TYPE_类型说明</td> 
  </tr> 
  <tr> 
   <td>NAME_</td> 
   <td>变量名称</td> 
   <td>VARCHAR(255)</td> 
   <td>&nbsp;</td> 
   <td>变量名称</td> 
  </tr> 
  <tr> 
   <td>EXECUTION_ID_</td> 
   <td>执行实例ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>执行的ID</td> 
  </tr> 
  <tr> 
   <td>PROC_INST_ID_</td> 
   <td>流程实例Id</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>流程实例ID</td> 
  </tr> 
  <tr> 
   <td>TASK_ID_</td> 
   <td>任务id</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>节点实例ID(Local）</td> 
  </tr> 
  <tr> 
   <td>BYTEARRAY_ID_</td> 
   <td>字节组ID</td> 
   <td>VARCHAR(64)</td> 
   <td>是</td> 
   <td>字节表的ID（ACT_GE_BYTEARRAY）</td> 
  </tr> 
  <tr> 
   <td>DOUBLE_</td> 
   <td>DOUBLE_</td> 
   <td>DOUBLE</td> 
   <td>是</td> 
   <td>存储变量类型为Double</td> 
  </tr> 
  <tr> 
   <td>LONG_</td> 
   <td>LONG_</td> 
   <td>BIGINT(20)</td> 
   <td>是</td> 
   <td>存储变量类型为long</td> 
  </tr> 
  <tr> 
   <td>TEXT_</td> 
   <td>TEXT_</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>存储变量值类型为String，如此处存储持久化对象时，值jpa对象的class</td> 
  </tr> 
  <tr> 
   <td>TEXT2_</td> 
   <td>TEXT2_</td> 
   <td>VARCHAR(4000)</td> 
   <td>是</td> 
   <td>此处存储的是JPA持久化对象时，才会有值。此值为对象ID</td> 
  </tr> 
 </tbody> 
</table>