SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for act_evt_log
-- ----------------------------
DROP TABLE IF EXISTS `act_evt_log`;
CREATE TABLE `act_evt_log` (
`LOG_NR_` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '日志编号，自增长的唯一标识',
`TYPE_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '事件类型',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID',
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务ID',
`TIME_STAMP_` timestamp(3) NOT NULL COMMENT '时间戳，记录事件发生的时间',
`USER_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户ID，关联操作的用户',
`DATA_` longblob NULL COMMENT '事件相关的数据，以二进制大对象形式存储',
`LOCK_OWNER_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '锁所有者，用于并发控制相关场景',
`LOCK_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '锁时间，记录锁被获取或释放等相关时间',
`IS_PROCESSED_` tinyint(0) NULL DEFAULT 0 COMMENT '是否已处理的标识，0表示未处理，1表示已处理',
PRIMARY KEY (`LOG_NR_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '事件日志表：用于记录工作流相关的各种事件信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_evt_log
-- ----------------------------
-- ----------------------------
-- Table structure for act_ge_bytearray
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_bytearray`;
CREATE TABLE `act_ge_bytearray` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，用于记录数据的修订版本',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '名称，方便对存储的数据进行识别和描述',
`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '部署ID，关联对应的部署信息',
`BYTES_` longblob NULL COMMENT '实际存储的二进制数据内容',
`GENERATED_` tinyint(0) NULL DEFAULT NULL COMMENT '是否自动生成的标识，用于区分数据来源情况',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_FK_BYTEARR_DEPL`(`DEPLOYMENT_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '通用字节数组表：用于存储各种二进制数据，比如流程定义相关的资源文件等内容。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ge_bytearray
-- ----------------------------
-- ----------------------------
-- Table structure for act_ge_property
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_property`;
CREATE TABLE `act_ge_property` (
`NAME_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '属性名称，唯一标识一个属性',
`VALUE_` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '属性值，对应属性名称所存储的具体内容',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录属性值的修订情况',
PRIMARY KEY (`NAME_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '通用属性表：用于存储系统或工作流相关的各种属性信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ge_property
-- ----------------------------
INSERT INTO `act_ge_property` VALUES ('cfg.execution-related-entities-count', 'false', 1);
INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', 1);
INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(7.1.0-M6)', 1);
INSERT INTO `act_ge_property` VALUES ('schema.version', '7.1.0-M6', 1);
-- ----------------------------
-- Table structure for act_hi_actinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_actinst`;
CREATE TABLE `act_hi_actinst` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '活动实例的唯一标识ID',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '流程定义ID，关联对应的流程定义',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '流程实例ID，属于哪个流程实例下的活动',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '执行实例ID，具体执行的实例标识',
`ACT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '活动ID，在流程定义中活动的唯一标识',
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务ID，若活动关联任务则记录任务标识',
`CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '调用的子流程实例ID，用于子流程相关场景',
`ACT_NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '活动名称，方便查看和识别活动内容',
`ACT_TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '活动类型，比如用户任务、服务任务等类型区分',
`ASSIGNEE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务执行人，记录执行该活动任务的用户',
`START_TIME_` datetime(3) NOT NULL COMMENT '开始时间，活动开始执行的时间',
`END_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '结束时间，活动结束执行的时间',
`DURATION_` bigint(0) NULL DEFAULT NULL COMMENT '持续时间，活动从开始到结束所经历的时长',
`DELETE_REASON_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '删除原因，若活动实例被删除记录相应原因',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_HI_ACT_INST_START`(`START_TIME_`) USING BTREE,
INDEX `ACT_IDX_HI_ACT_INST_END`(`END_TIME_`) USING BTREE,
INDEX `ACT_IDX_HI_ACT_INST_PROCINST`(`PROC_INST_ID_`, `ACT_ID_`) USING BTREE,
INDEX `ACT_IDX_HI_ACT_INST_EXEC`(`EXECUTION_ID_`, `ACT_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '历史活动实例表：记录工作流中已经执行过的活动实例相关信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_hi_actinst
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_attachment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_attachment`;
CREATE TABLE `act_hi_attachment` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '附件的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录附件相关信息的修订情况',
`USER_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户ID，关联上传或关联该附件的用户',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '附件名称，方便识别附件内容',
`DESCRIPTION_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '附件描述，对附件的详细说明',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '附件类型，比如文档类型、图片类型等区分',
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务ID，关联到具体任务下的附件',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，属于哪个流程实例的附件',
`URL_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '附件的访问链接，若有外部存储可通过此链接访问',
`CONTENT_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '内容ID，关联实际存储附件内容的标识（可能和其他存储表关联）',
`TIME_` datetime(3) NULL DEFAULT NULL COMMENT '时间，附件相关操作的时间记录，比如上传时间等',
PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '历史附件表：记录工作流中历史的附件相关信息，比如流程相关文档等附件。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_hi_attachment
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_comment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_comment`;
CREATE TABLE `act_hi_comment` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '评论的唯一标识ID',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '评论类型，可用于区分不同目的的评论，比如审批意见、备注等',
`TIME_` datetime(3) NOT NULL COMMENT '时间，评论发表的时间',
`USER_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户ID，发表评论的用户标识',
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务ID，关联到具体任务下的评论',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，属于哪个流程实例的评论',
`ACTION_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '操作，评论关联的具体操作描述（可选）',
`MESSAGE_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '评论内容，具体的文字消息',
`FULL_MSG_` longblob NULL COMMENT '完整消息内容，可能以二进制大对象存储更复杂的消息（比如带格式等）',
PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '历史评论表：记录工作流中历史的评论信息，用户可以对任务、流程等发表评论记录在此表。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_hi_comment
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_detail
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_detail`;
CREATE TABLE `act_hi_detail` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '详情记录的唯一标识ID',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '详情类型，区分不同种类的详细信息，如变量更新、任务状态变化等',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，对应的执行实例',
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务ID，关联的任务（若有）',
`ACT_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '活动实例ID，对应的活动实例（若相关）',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '名称，用于标识该详细信息的具体名称（比如变量名等）',
`VAR_TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '变量类型，若详情是关于变量的则记录其类型',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录该详情信息的修订情况',
`TIME_` datetime(3) NOT NULL COMMENT '时间，该详细信息产生的时间',
`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '字节数组ID，关联相关二进制数据（若有）',
`DOUBLE_` double NULL DEFAULT NULL COMMENT '双精度数值，若详情涉及双精度数据则记录在此',
`LONG_` bigint(0) NULL DEFAULT NULL COMMENT '长整型数值，若详情涉及长整型数据则记录在此',
`TEXT_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '文本内容，若详情涉及文本信息则记录在此',
`TEXT2_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '备用文本内容，可用于其他相关文本信息存储',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_HI_DETAIL_PROC_INST`(`PROC_INST_ID_`) USING BTREE,
INDEX `ACT_IDX_HI_DETAIL_ACT_INST`(`ACT_INST_ID_`) USING BTREE,
INDEX `ACT_IDX_HI_DETAIL_TIME`(`TIME_`) USING BTREE,
INDEX `ACT_IDX_HI_DETAIL_NAME`(`NAME_`) USING BTREE,
INDEX `ACT_IDX_HI_DETAIL_TASK_ID`(`TASK_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '历史详情表：用于记录工作流历史执行过程中的各种详细信息，比如变量变化等细节。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_hi_detail
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_identitylink`;
CREATE TABLE `act_hi_identitylink` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '关联关系的唯一标识ID',
`GROUP_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '组ID，关联的用户组标识（若有）',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '关联类型，比如参与者、负责人等类型区分',
`USER_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户ID，关联的用户标识',
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务ID，关联到具体任务的身份关系',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，属于哪个流程实例的身份关联',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_HI_IDENT_LNK_USER`(`USER_ID_`) USING BTREE,
INDEX `ACT_IDX_HI_IDENT_LNK_TASK`(`TASK_ID_`) USING BTREE,
INDEX `ACT_IDX_HI_IDENT_LNK_PROCINST`(`PROC_INST_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '历史身份关联表：记录工作流历史中用户、组等与任务、流程实例等的关联关系信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_hi_identitylink
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_procinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_procinst`;
CREATE TABLE `act_hi_procinst` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '流程实例的唯一标识ID',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '流程实例ID，自身的ID（冗余存储，方便查询等）',
`BUSINESS_KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '业务键，用于关联业务系统中的业务对象，方便流程与业务对接',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '流程定义ID，关联对应的流程定义',
`START_TIME_` datetime(3) NOT NULL COMMENT '开始时间，流程实例开始执行的时间',
`END_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '结束时间，流程实例结束执行的时间',
`DURATION_` bigint(0) NULL DEFAULT NULL COMMENT '持续时间，流程实例从开始到结束所经历的时长',
`START_USER_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '启动用户ID，记录启动该流程实例的用户',
`START_ACT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '开始活动ID，流程开始时对应的活动标识',
`END_ACT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '结束活动ID，流程结束时对应的活动标识',
`SUPER_PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '上级流程实例ID，用于子流程等嵌套流程场景下的关联',
`DELETE_REASON_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '删除原因，若流程实例被删除记录相应原因',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
PRIMARY KEY (`ID_`) USING BTREE,
UNIQUE INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,
INDEX `ACT_IDX_HI_PRO_INST_END`(`END_TIME_`) USING BTREE,
INDEX `ACT_IDX_HI_PRO_I_BUSKEY`(`BUSINESS_KEY_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '历史流程实例表：记录工作流中已经执行过的流程实例的相关信息，用于追溯流程执行情况。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_hi_procinst
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_taskinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_taskinst`;
CREATE TABLE `act_hi_taskinst` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '任务实例的唯一标识ID',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义',
`TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务定义键，在流程定义中任务的唯一标识键值',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，对应的执行实例',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务名称，方便识别任务内容',
`PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '父任务ID，若任务存在父子层级关系则记录父任务标识',
`DESCRIPTION_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务描述，对任务的详细说明',
`OWNER_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务所有者，拥有该任务管理权限等的用户',
`ASSIGNEE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务执行人，实际执行该任务的用户',
`START_TIME_` datetime(3) NOT NULL COMMENT '开始时间，任务开始执行的时间',
`CLAIM_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '认领时间，若任务需要被用户认领则记录认领的时间',
`END_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '结束时间，任务结束执行的时间',
`DURATION_` bigint(0) NULL DEFAULT NULL COMMENT '持续时间，任务从开始到结束所经历的时长',
`DELETE_REASON_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '删除原因，若任务实例被删除记录相应原因',
`PRIORITY_` int(0) NULL DEFAULT NULL COMMENT '优先级，任务的优先级数值，用于任务排序等场景',
`DUE_DATE_` datetime(3) NULL DEFAULT NULL COMMENT '截止日期，任务要求完成的时间期限',
`FORM_KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '表单键，关联任务对应的表单（若有）',
`CATEGORY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '类别，任务所属的分类（可自定义分类规则）',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_HI_TASK_INST_PROCINST`(`PROC_INST_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '历史任务实例表：用于记录工作流中已经执行过的任务实例相关信息，方便查看任务执行历史情况。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_hi_taskinst
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_varinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_varinst`;
CREATE TABLE `act_hi_varinst` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '变量实例的唯一标识ID',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，对应的执行实例',
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务ID，关联的任务（若变量与任务相关）',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '变量名称，唯一标识一个变量',
`VAR_TYPE_` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '变量类型，如字符串、整数、日期等类型区分',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录变量实例相关信息的修订情况',
`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '字节数组ID，若变量值以二进制形式存储则关联对应的字节数组标识',
`DOUBLE_` double NULL DEFAULT NULL COMMENT '双精度数值，若变量值为双精度类型则记录在此',
`LONG_` bigint(0) NULL DEFAULT NULL COMMENT '长整型数值，若变量值为长整型类型则记录在此',
`TEXT_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '文本内容，若变量值为文本类型则记录在此',
`TEXT2_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '备用文本内容，可用于存储其他相关文本信息',
`CREATE_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '创建时间，变量实例创建的时间',
`LAST_UPDATED_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '最后更新时间，变量实例最后一次被修改的时间',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_HI_PROCVAR_PROC_INST`(`PROC_INST_ID_`) USING BTREE,
INDEX `ACT_IDX_HI_PROCVAR_NAME_TYPE`(`NAME_`, `VAR_TYPE_`) USING BTREE,
INDEX `ACT_IDX_HI_PROCVAR_TASK_ID`(`TASK_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '历史变量实例表：记录工作流历史执行过程中变量实例的相关信息，包括变量值变化等情况。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_hi_varinst
-- ----------------------------
-- ----------------------------
-- Table structure for act_procdef_info
-- ----------------------------
DROP TABLE IF EXISTS `act_procdef_info`;
CREATE TABLE `act_procdef_info` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '唯一标识ID',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '流程定义ID，关联对应的流程定义',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录该流程定义信息的修订情况',
`INFO_JSON_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '信息JSON的ID，关联存储具体信息内容的字节数组（通常以JSON格式存储信息）',
PRIMARY KEY (`ID_`) USING BTREE,
UNIQUE INDEX `ACT_UNIQ_INFO_PROCDEF`(`PROC_DEF_ID_`) USING BTREE,
INDEX `ACT_IDX_INFO_PROCDEF`(`PROC_DEF_ID_`) USING BTREE,
INDEX `ACT_FK_INFO_JSON_BA`(`INFO_JSON_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '流程定义信息表：用于存储流程定义相关的额外信息，如流程描述等详细信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_procdef_info
-- ----------------------------
-- ----------------------------
-- Table structure for act_re_deployment
-- ----------------------------
DROP TABLE IF EXISTS `act_re_deployment`;
CREATE TABLE `act_re_deployment` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '部署的唯一标识ID',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '部署名称，方便识别部署内容',
`CATEGORY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '类别，部署所属的分类（可自定义分类规则）',
`KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '键，用于唯一标识部署的一个关键值（可能和流程定义等相关）',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
`DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '部署时间，记录资源进行部署操作的时间',
`ENGINE_VERSION_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '引擎版本，工作流引擎的版本号',
`VERSION_` int(0) NULL DEFAULT 1 COMMENT '版本，部署资源的版本号（默认初始为1，可递增）',
`PROJECT_RELEASE_VERSION_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '项目发布版本，关联项目整体发布的版本情况',
PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '部署表：用于记录工作流相关资源的部署情况，如流程定义文件等的部署信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_re_deployment
-- ----------------------------
INSERT INTO `act_re_deployment` VALUES ('1ddb2bbb-8c8f-11f0-bafd-18c04d133766', 'SpringAutoDeployment', NULL, NULL, '', '2025-09-08 16:37:55.757', NULL, 1, NULL);
-- ----------------------------
-- Table structure for act_re_model
-- ----------------------------
DROP TABLE IF EXISTS `act_re_model`;
CREATE TABLE `act_re_model` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '模型的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录模型相关信息的修订情况',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '模型名称，方便识别和区分不同模型',
`KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '键，模型的唯一标识键值（类似流程定义的关键标识）',
`CATEGORY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '类别，模型所属的分类（可自定义分类规则）',
`CREATE_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '创建时间，模型创建的时间记录',
`LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '最后更新时间，模型最后一次被修改的时间',
`VERSION_` int(0) NULL DEFAULT NULL COMMENT '版本，模型的版本号（可根据修改情况递增等）',
`META_INFO_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '元信息，存储模型相关的额外描述等元数据信息',
`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '部署ID，关联对应的部署情况（若模型被部署）',
`EDITOR_SOURCE_VALUE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '编辑器源值ID，关联存储模型编辑器相关源数据的字节数组标识',
`EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '编辑器额外源值ID，关联存储模型编辑器额外源数据的字节数组标识',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_FK_MODEL_SOURCE`(`EDITOR_SOURCE_VALUE_ID_`) USING BTREE,
INDEX `ACT_FK_MODEL_SOURCE_EXTRA`(`EDITOR_SOURCE_EXTRA_VALUE_ID_`) USING BTREE,
INDEX `ACT_FK_MODEL_DEPLOYMENT`(`DEPLOYMENT_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '模型表：用于存储工作流相关的模型信息，比如流程设计模型等内容。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_re_model
-- ----------------------------
-- ----------------------------
-- Table structure for act_re_procdef
-- ----------------------------
DROP TABLE IF EXISTS `act_re_procdef`;
CREATE TABLE `act_re_procdef` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '流程定义的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录流程定义的修订情况',
`CATEGORY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '类别，流程定义所属的分类（可自定义分类规则）',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程名称，方便识别流程内容',
`KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '流程定义键，唯一标识一个流程定义，用于区分不同流程',
`VERSION_` int(0) NOT NULL COMMENT '版本号，流程定义的版本，每次更新会递增',
`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '部署ID，关联对应的部署情况',
`RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '资源名称，流程定义相关资源文件的名称（如BPMN文件等）',
`DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '图形资源名称，流程定义相关图形资源文件的名称（如流程图图片等，若有）',
`DESCRIPTION_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '描述，对流程定义的详细说明',
`HAS_START_FORM_KEY_` tinyint(0) NULL DEFAULT NULL COMMENT '是否有启动表单键，标识流程启动时是否关联表单',
`HAS_GRAPHICAL_NOTATION_` tinyint(0) NULL DEFAULT NULL COMMENT '是否有图形表示，标识流程定义是否有对应的图形展示（如流程图）',
`SUSPENSION_STATE_` int(0) NULL DEFAULT NULL COMMENT '暂停状态，用于表示流程定义是否处于暂停状态（如暂停使用等情况）',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
`ENGINE_VERSION_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '引擎版本，工作流引擎的版本号适用该流程定义',
`APP_VERSION_` int(0) NULL DEFAULT NULL COMMENT '应用版本，关联应用的版本号（若流程与应用相关）',
PRIMARY KEY (`ID_`) USING BTREE,
UNIQUE INDEX `ACT_UNIQ_PROCDEF`(`KEY_`, `VERSION_`, `TENANT_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '流程定义表：用于存储工作流中流程的定义信息，包括流程结构、节点等定义内容。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_re_procdef
-- ----------------------------
-- ----------------------------
-- Table structure for act_ru_deadletter_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_deadletter_job`;
CREATE TABLE `act_ru_deadletter_job` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '死信任务的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录死信任务相关信息的修订情况',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '任务类型，区分不同种类的死信任务（如定时任务、服务任务等出现异常成为死信的情况）',
`EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL COMMENT '是否独占，标识该任务是否独占执行（互斥等情况）',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，关联对应的执行实例',
`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义',
`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常堆栈ID，关联存储异常堆栈信息的字节数组标识',
`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常消息，记录任务出现异常的具体文字描述',
`DUEDATE_` timestamp(3) NULL DEFAULT NULL COMMENT '截止日期，任务原本预期完成的时间（可能用于判断超时等情况）',
`REPEAT_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '重复规则，若任务可重复执行相关的规则描述（若有）',
`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '处理程序类型，处理该死信任务的程序类型（如重试机制对应的处理程序等）',
`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '处理程序配置，对应处理程序的配置参数信息',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_FK_DEADLETTER_JOB_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
INDEX `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_`) USING BTREE,
INDEX `ACT_FK_DEADLETTER_JOB_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
INDEX `ACT_FK_DEADLETTER_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '死信任务表：用于记录工作流中出现异常等情况进入死信队列的任务相关信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_deadletter_job
-- ----------------------------
-- ----------------------------
-- 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 utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '事件订阅的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录事件订阅相关信息的修订情况',
`EVENT_TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '事件类型，明确是哪种类型的工作流事件，比如任务创建、流程启动等类型',
`EVENT_NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '事件名称，对具体事件更具描述性的名称',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，关联对应的执行实例（若事件与执行相关）',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例（若事件与流程实例相关）',
`ACTIVITY_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '活动ID，关联对应的活动（若事件与特定活动相关）',
`CONFIGURATION_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '配置信息，针对该事件订阅的一些额外配置参数等内容',
`CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间，记录事件订阅创建的时间点，默认取当前时间',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义（事件基于的流程定义）',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_EVENT_SUBSCR_CONFIG_`(`CONFIGURATION_`) USING BTREE,
INDEX `ACT_FK_EVENT_EXEC`(`EXECUTION_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '运行时事件订阅表：用于记录工作流运行过程中对各类事件进行订阅的相关信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_event_subscr
-- ----------------------------
-- ----------------------------
-- Table structure for act_ru_execution
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_execution`;
CREATE TABLE `act_ru_execution` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '执行实例的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录执行实例相关信息的修订情况',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例',
`BUSINESS_KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '业务键，关联业务系统中的业务对象，便于流程与业务对接',
`PARENT_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '父实例ID，若执行实例存在父子层级关系，则记录父执行实例的标识',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义',
`SUPER_EXEC_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '上级执行实例，用于嵌套等复杂流程场景下的上级执行关联',
`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '根流程实例ID，整个流程树的根流程实例标识',
`ACT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '活动ID，当前执行到的活动标识',
`IS_ACTIVE_` tinyint(0) NULL DEFAULT NULL COMMENT '是否活跃，标识该执行实例当前是否处于活动执行状态',
`IS_CONCURRENT_` tinyint(0) NULL DEFAULT NULL COMMENT '是否并发，判断该执行实例是否处于并发执行场景',
`IS_SCOPE_` tinyint(0) NULL DEFAULT NULL COMMENT '是否作用域，用于确定执行实例是否作为一个作用域范围（涉及变量等作用域相关概念）',
`IS_EVENT_SCOPE_` tinyint(0) NULL DEFAULT NULL COMMENT '是否事件作用域，标识是否作为事件相关的作用域情况',
`IS_MI_ROOT_` tinyint(0) NULL DEFAULT NULL COMMENT '是否多实例根，判断是否为多实例流程的根实例情况',
`SUSPENSION_STATE_` int(0) NULL DEFAULT NULL COMMENT '暂停状态，记录执行实例是否处于暂停状态',
`CACHED_ENT_STATE_` int(0) NULL DEFAULT NULL COMMENT '缓存实体状态，用于记录执行实例相关实体在缓存中的状态情况（内部缓存机制相关）',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '名称，给执行实例赋予的一个便于识别的名称（可选）',
`START_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '开始时间，执行实例开始执行的时间',
`START_USER_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '启动用户ID，记录启动该执行实例的用户标识',
`LOCK_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '锁时间，涉及并发等控制场景下锁获取或释放的时间记录',
`IS_COUNT_ENABLED_` tinyint(0) NULL DEFAULT NULL COMMENT '是否计数启用，标识是否开启相关计数功能（比如任务数量等计数）',
`EVT_SUBSCR_COUNT_` int(0) NULL DEFAULT NULL COMMENT '事件订阅数量，记录该执行实例相关的事件订阅数量情况',
`TASK_COUNT_` int(0) NULL DEFAULT NULL COMMENT '任务数量，当前执行实例下包含的任务数量统计',
`JOB_COUNT_` int(0) NULL DEFAULT NULL COMMENT '作业数量，相关作业的数量统计（如定时作业等）',
`TIMER_JOB_COUNT_` int(0) NULL DEFAULT NULL COMMENT '定时器作业数量，专门针对定时器类型作业的数量统计',
`SUSP_JOB_COUNT_` int(0) NULL DEFAULT NULL COMMENT '暂停作业数量，处于暂停状态的作业数量统计',
`DEADLETTER_JOB_COUNT_` int(0) NULL DEFAULT NULL COMMENT '死信作业数量，进入死信队列的作业数量统计',
`VAR_COUNT_` int(0) NULL DEFAULT NULL COMMENT '变量数量，该执行实例涉及的变量数量统计',
`ID_LINK_COUNT_` int(0) NULL DEFAULT NULL COMMENT '标识链接数量，相关标识链接的数量统计（用于关联等情况）',
`APP_VERSION_` int(0) NULL DEFAULT NULL COMMENT '应用版本，关联应用的版本号（若执行实例与应用相关）',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_EXEC_BUSKEY`(`BUSINESS_KEY_`) USING BTREE,
INDEX `ACT_IDC_EXEC_ROOT`(`ROOT_PROC_INST_ID_`) USING BTREE,
INDEX `ACT_FK_EXE_PROCINST`(`PROC_INST_ID_`) USING BTREE,
INDEX `ACT_FK_EXE_PARENT`(`PARENT_ID_`) USING BTREE,
INDEX `ACT_FK_EXE_SUPER`(`SUPER_EXEC_`) USING BTREE,
INDEX `ACT_FK_EXE_PROCDEF`(`PROC_DEF_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '运行时执行实例表：用于记录工作流正在运行的执行实例相关信息，反映流程执行的实时状态。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_execution
-- ----------------------------
-- ----------------------------
-- Table structure for act_ru_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_identitylink`;
CREATE TABLE `act_ru_identitylink` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '关联关系的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录身份关联关系相关信息的修订情况',
`GROUP_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '组ID，关联的用户组标识（若有）',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '关联类型，比如参与者、负责人等类型区分',
`USER_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户ID，关联的用户标识',
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务ID，关联到具体任务的身份关系',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，属于哪个流程实例的身份关联',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义（身份关联基于的流程定义）',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_IDENT_LNK_USER`(`USER_ID_`) USING BTREE,
INDEX `ACT_IDX_IDENT_LNK_GROUP`(`GROUP_ID_`) USING BTREE,
INDEX `ACT_IDX_ATHRZ_PROCEDEF`(`PROC_DEF_ID_`) USING BTREE,
INDEX `ACT_FK_TSKASS_TASK`(`TASK_ID_`) USING BTREE,
INDEX `ACT_FK_IDL_PROCINST`(`PROC_INST_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '运行时身份关联表：用于记录工作流运行时用户、组等与任务、流程实例等之间的关联关系信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_identitylink
-- ----------------------------
-- ----------------------------
-- Table structure for act_ru_integration
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_integration`;
CREATE TABLE `act_ru_integration` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '集成记录的唯一标识ID',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，关联对应的执行实例（集成操作基于的执行实例）',
`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例（集成操作所在的流程实例）',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义（集成操作依据的流程定义）',
`FLOW_NODE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程节点ID，关联到具体流程节点（集成操作发生的节点位置）',
`CREATED_DATE_` timestamp(3) NULL DEFAULT NULL COMMENT '创建时间，记录集成相关记录创建的时间',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_FK_INT_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
INDEX `ACT_FK_INT_PROC_INST`(`PROCESS_INSTANCE_ID_`) USING BTREE,
INDEX `ACT_FK_INT_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_INT_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_INT_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_INT_PROC_INST` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '运行时集成表：用于记录工作流运行过程中与外部系统集成相关的信息，比如调用外部服务等情况。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_integration
-- ----------------------------
-- ----------------------------
-- Table structure for act_ru_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_job`;
CREATE TABLE `act_ru_job` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '作业的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录作业相关信息的修订情况',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '作业类型，区分不同种类的作业，比如定时作业、异步作业等类型',
`LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '锁过期时间，涉及作业并发控制等场景下锁的过期时间记录',
`LOCK_OWNER_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '锁所有者，记录获取锁的对象（通常是执行作业的相关组件等）',
`EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL COMMENT '是否独占，标识该作业是否独占执行（互斥等情况）',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，关联对应的执行实例（作业基于的执行实例）',
`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例（作业所在的流程实例）',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义（作业依据的流程定义）',
`RETRIES_` int(0) NULL DEFAULT NULL COMMENT '重试次数，作业执行失败后进行重试的次数统计',
`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常堆栈ID，关联存储异常堆栈信息的字节数组标识（作业出现异常时）',
`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常消息，记录作业出现异常的具体文字描述',
`DUEDATE_` timestamp(3) NULL DEFAULT NULL COMMENT '截止日期，作业预期完成的时间（如定时作业的触发时间等）',
`REPEAT_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '重复规则，作业可重复执行相关的规则描述（若有）',
`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '处理程序类型，处理该作业的程序类型（如执行逻辑对应的处理程序等）',
`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '处理程序配置，对应处理程序的配置参数信息',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_FK_JOB_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
INDEX `ACT_FK_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_`) USING BTREE,
INDEX `ACT_FK_JOB_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
INDEX `ACT_FK_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '运行时作业表：用于记录工作流运行过程中各种作业（如定时作业等）的相关信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_job
-- ----------------------------
-- ----------------------------
-- Table structure for act_ru_suspended_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_suspended_job`;
CREATE TABLE `act_ru_suspended_job` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '暂停作业的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录暂停作业相关信息的修订情况',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '作业类型，区分不同种类的暂停作业（同普通作业的类型分类类似）',
`EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL COMMENT '是否独占，标识该暂停作业是否独占执行（互斥等情况）',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，关联对应的执行实例（暂停作业基于的执行实例）',
`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例（暂停作业所在的流程实例）',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义（暂停作业依据的流程定义）',
`RETRIES_` int(0) NULL DEFAULT NULL COMMENT '重试次数，暂停作业后续若恢复执行失败后进行重试的次数统计',
`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常堆栈ID，关联存储异常堆栈信息的字节数组标识（暂停作业出现异常时）',
`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常消息，记录暂停作业出现异常的具体文字描述',
`DUEDATE_` timestamp(3) NULL DEFAULT NULL COMMENT '截止日期，暂停作业原本预期完成的时间（可能用于判断超时等情况）',
`REPEAT_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '重复规则，暂停作业可重复执行相关的规则描述（若有）',
`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '处理程序类型，处理该暂停作业的程序类型（如恢复执行等相关处理程序）',
`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '处理程序配置，对应处理程序的配置参数信息',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_FK_SUSPENDED_JOB_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
INDEX `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_`) USING BTREE,
INDEX `ACT_FK_SUSPENDED_JOB_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
INDEX `ACT_FK_SUSPENDED_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '运行时暂停作业表：用于记录工作流运行过程中处于暂停状态的作业相关信息。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_suspended_job
-- ----------------------------
-- ----------------------------
-- Table structure for act_ru_task
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_task`;
CREATE TABLE `act_ru_task` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '任务的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录任务相关信息的修订情况',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，关联对应的执行实例（任务所属的执行实例）',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务名称，方便识别任务内容',
`BUSINESS_KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '业务键，关联业务系统中的业务对象（任务与业务对接的标识）',
`PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '父任务ID，若任务存在父子层级关系，则记录父任务的标识',
`DESCRIPTION_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务描述，对任务的详细说明',
`TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务定义键，在流程定义中任务的唯一标识键值',
`OWNER_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务所有者，拥有该任务管理权限等的用户',
`ASSIGNEE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务执行人，实际执行该任务的用户',
`DELEGATION_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '委托情况，记录任务是否被委托以及相关委托信息（若有）',
`PRIORITY_` int(0) NULL DEFAULT NULL COMMENT '优先级，任务的优先级数值，用于任务排序等场景',
`CREATE_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '创建时间，任务创建的时间记录',
`DUE_DATE_` datetime(3) NULL DEFAULT NULL COMMENT '截止日期，任务要求完成的时间期限',
`CATEGORY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '类别，任务所属的分类（可自定义分类规则）',
`SUSPENSION_STATE_` int(0) NULL DEFAULT NULL COMMENT '暂停状态，记录任务是否处于暂停状态',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
`FORM_KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '表单键，关联任务对应的表单（若有）',
`CLAIM_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '认领时间，若任务需要被用户认领则记录认领的时间',
`APP_VERSION_` int(0) NULL DEFAULT NULL COMMENT '应用版本，关联应用的版本号（若任务与应用相关）',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_TASK_CREATE`(`CREATE_TIME_`) USING BTREE,
INDEX `ACT_FK_TASK_EXE`(`EXECUTION_ID_`) USING BTREE,
INDEX `ACT_FK_TASK_PROCINST`(`PROC_INST_ID_`) USING BTREE,
INDEX `ACT_FK_TASK_PROCDEF`(`PROC_DEF_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '运行时任务表：用于记录工作流运行过程中正在执行或待执行的任务相关信息，反映任务的实时状态。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_task
-- ----------------------------
-- ----------------------------
-- Table structure for act_ru_timer_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_timer_job`;
CREATE TABLE `act_ru_timer_job` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '定时器作业的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录定时器作业相关信息的修订情况',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '作业类型，明确为定时器作业类型',
`LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '锁过期时间，涉及定时器作业并发控制等场景下锁的过期时间记录',
`LOCK_OWNER_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '锁所有者，记录获取定时器作业锁的对象（通常是执行作业的相关组件等）',
`EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL COMMENT '是否独占，标识该定时器作业是否独占执行（互斥等情况）',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，关联对应的执行实例（定时器作业基于的执行实例）',
`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例（定时器作业所在的流程实例）',
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义ID，关联对应的流程定义（定时器作业依据的流程定义）',
`RETRIES_` int(0) NULL DEFAULT NULL COMMENT '重试次数，定时器作业执行失败后进行重试的次数统计',
`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常堆栈ID，关联存储异常堆栈信息的字节数组标识（定时器作业出现异常时）',
`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常消息，记录定时器作业出现异常的具体文字描述',
`DUEDATE_` timestamp(3) NULL DEFAULT NULL COMMENT '截止日期，定时器作业预期触发执行的时间',
`REPEAT_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '重复规则，定时器作业可重复触发执行相关的规则描述（若有）',
`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '处理程序类型，处理该定时器作业的程序类型（如触发执行逻辑对应的处理程序等）',
`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '处理程序配置，对应处理程序的配置参数信息',
`TENANT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户ID，用于多租户场景下的区分标识',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_FK_TIMER_JOB_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
INDEX `ACT_FK_TIMER_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_`) USING BTREE,
INDEX `ACT_FK_TIMER_JOB_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
INDEX `ACT_FK_TIMER_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '运行时定时器作业表：用于记录工作流运行过程中定时器类型作业的相关信息，如定时触发的任务等情况。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_timer_job
-- ----------------------------
-- ----------------------------
-- Table structure for act_ru_variable
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_variable`;
CREATE TABLE `act_ru_variable` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '变量的唯一标识ID',
`REV_` int(0) NULL DEFAULT NULL COMMENT '版本号，记录变量相关信息的修订情况',
`TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '变量类型，如字符串、整数、日期等类型区分',
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '变量名称，唯一标识一个变量',
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例ID，关联对应的执行实例（变量所在的执行实例）',
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例ID，所属的流程实例',
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务ID，关联的任务（若变量与任务相关）',
`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '字节数组ID，若变量值以二进制形式存储则关联对应的字节数组标识',
`DOUBLE_` double NULL DEFAULT NULL COMMENT '双精度数值，若变量值为双精度类型则记录在此',
`LONG_` bigint(0) NULL DEFAULT NULL COMMENT '长整型数值，若变量值为长整型类型则记录在此',
`TEXT_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '文本内容，若变量值为文本类型则记录在此',
`TEXT2_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '备用文本内容，可用于存储其他相关文本信息',
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_IDX_VARIABLE_TASK_ID`(`TASK_ID_`) USING BTREE,
INDEX `ACT_FK_VAR_EXE`(`EXECUTION_ID_`) USING BTREE,
INDEX `ACT_FK_VAR_PROCINST`(`PROC_INST_ID_`) USING BTREE,
INDEX `ACT_FK_VAR_BYTEARRAY`(`BYTEARRAY_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '运行时变量表：用于记录工作流运行过程中使用的变量相关信息，包括变量的值、类型等情况。' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ru_variable
-- ----------------------------
SET FOREIGN_KEY_CHECKS = 1;
浙公网安备 33010602011771号