Activiti 5.22.0数据库表结构（21张表全部表和字段中文注释和取值说明）

/* Activiti 5.22.0数据库表结构-建表版 21张表全部表和字段中文注释和取值说明 还有4个ACT_ID_开头的表这里忽略了，因为这几个表通常是用自己的业务系统的表 */ DROP TABLE IF EXISTS `act_evt_log`; CREATE TABLE `act_evt_log` ( `LOG_NR_` bigint NOT NULL AUTO_INCREMENT COMMENT '自增长ID主键', `TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '类型', `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '流程定义ID', `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '流程实例ID', `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '执行实例ID', `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '节点实例ID', `TIME_STAMP_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '时间戳', `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '用户ID', `DATA_` longblob COMMENT '一些额外参数，例如 IP地址 等', `LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '挂起者 暂时没有用到', `LOCK_TIME_` timestamp NULL DEFAULT NULL COMMENT '挂起时间 暂时没有用到', `IS_PROCESSED_` tinyint DEFAULT '0' COMMENT '是否处理过了 暂时没有用到', PRIMARY KEY (`LOG_NR_`) COMMENT '主键唯一索引' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='Activiti 事件日志表'; /*Table structure for table `act_ge_bytearray` */ DROP TABLE IF EXISTS `act_ge_bytearray`; CREATE TABLE `act_ge_bytearray` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键ID', `REV_` int DEFAULT NULL COMMENT '乐观锁 默认值 NULL，version版', `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '名称 部署文件名称，如', `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '部署ID 部署表ID', `BYTES_` longblob COMMENT '字节 部署文件', `GENERATED_` tinyint DEFAULT NULL COMMENT '是否是 0：为用户生成，1：为', PRIMARY KEY (`ID_`) COMMENT '主键唯一索引', KEY `act_ge_bytearray_ibfk_1` (`DEPLOYMENT_ID_`) COMMENT 'ACT_RE_DEPLOYMENT 表主键做外', CONSTRAINT `act_ge_bytearray_ibfk_1` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='Activiti 二进制数据表。保存流程定义图片和xml、Serializable(序列化)的变量,即保存所有二进制数据，特别注意类路\r\n径部署时候，不要把svn等隐藏文件或者其他与流程无关的文件也一起部署到该表中，会造成\r\n一些错误（可能导致流程定义无法删除）。'; /*Table structure for table `act_ge_property` */ DROP TABLE IF EXISTS `act_ge_property`; CREATE TABLE `act_ge_property` ( `NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键 schema.version、schema.history、next.dbid', `VALUE_` varchar(300) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '值 例如： 5.* 、 create(5.*)', `REV_` int DEFAULT NULL COMMENT '乐观锁 默认值 NULL，version版', PRIMARY KEY (`NAME_`) COMMENT '主键唯一索引' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin; /*Table structure for table `act_hi_actinst` */ DROP TABLE IF EXISTS `act_hi_actinst`; CREATE TABLE `act_hi_actinst` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键ID', `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '流程定义ID', `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '流程实例ID', `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '执行实例ID', `ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '节点ID', `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '节点实例ID 默认值 NULL，其他节点类型实例ID在这里为空', `CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '调用外部的流程实例ID 默认值NULL，调用外部流程的流程实例ID', `ACT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '节点名称 默认值 NULL，节点定义名称', `ACT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '节点类型 如startEvent、userTask', `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '签收人 默认值 NULL，节点签收人', `START_TIME_` datetime(3) NOT NULL COMMENT '开始时间 version版本，2016-11-15 11:30:00', `END_TIME_` datetime(3) DEFAULT NULL COMMENT '结束时间 默认值 NULL，2016-11-15 11:30:00', `DURATION_` bigint DEFAULT NULL COMMENT '耗时 默认值 NULL，毫秒值', `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '租户标识 默认值``', PRIMARY KEY (`ID_`) COMMENT '主键唯一索引', KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`) COMMENT '开始时间索引', KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`) COMMENT '结束时间索引', KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`) COMMENT '流程实例与节点联合索引', KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`) COMMENT '执行实例与节点联合索引。' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='历史节点表 历史活动信息。这里记录流程流转过的所有节点，与HI_TASKINST不同的是，taskinst只记录usertask内容。'; /*Table structure for table `act_hi_attachment` */ DROP TABLE IF EXISTS `act_hi_attachment`; CREATE TABLE `act_hi_attachment` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键ID', `REV_` int DEFAULT NULL COMMENT '乐观锁 默认值 NULL，version版本', `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '用户ID 默认值 NULL，用户标识', `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '名称 默认值 NULL', `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '描述 默认值 NULL', `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '类型 默认值 NULL，附件类型', `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '节点实例ID 默认值 NULL', `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '流程实例ID 默认值 NULL', `URL_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'URL附件地址 默认值 NULL，附件地址', `CONTENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '字节表的ID 默认值 NULL，ACT_GE_BYTEARRAY的ID', `TIME_` datetime(3) DEFAULT NULL COMMENT '乐观锁 默认值 NULL', PRIMARY KEY (`ID_`) COMMENT ' 主键唯一索引' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='历史附件表'; /*Table structure for table `act_hi_comment` */ DROP TABLE IF EXISTS `act_hi_comment`; CREATE TABLE `act_hi_comment` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键ID', `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '类型：event（事件）、comment（意见）', `TIME_` datetime(3) NOT NULL COMMENT '填写时间', `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '填写人ID', `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '节点实例ID 默认值 NULL', `PROC_INST_ID_` varchar(64) CHA