ACT_RU_ACTINST
时间: 2023-11-22 20:06:13 浏览: 43
ACT_RU_ACTINST是Activiti工作流引擎中的一个表,用于记录流程实例的执行流程。每个流程实例都会对应多个执行流程,每个执行流程都会在ACT_RU_ACTINST表中有一条记录。该表中的字段包括执行流程ID、流程定义ID、流程实例ID、任务ID、任务名称、任务类型、任务负责人、开始时间、结束时间等。可以通过查询ACT_RU_ACTINST表来获取流程实例的执行情况,以及每个任务的执行情况。
以下是一个查询ACT_RU_ACTINST表的SQL语句的例子:
```sql
SELECT * FROM ACT_RU_ACTINST WHERE PROC_DEF_ID_ = 'myProcess:1:4' AND EXECUTION_ID_ = '12345'
```
该语句查询了流程定义ID为myProcess:1:4,执行流程ID为12345的流程实例的执行情况。
相关问题
activiti-explorer mysql_Activiti explorer.war示例工程使用过程图解
以下是 activiti-explorer 和 mysql 的集成示例工程使用过程图解:
1. 下载并解压 activiti-explorer.war 文件,将其放入 Tomcat 服务器的 webapps 目录下。
2. 创建一个名为 activiti 的数据库,并将以下 SQL 语句执行:
```
CREATE TABLE `ACT_RE_DEPLOYMENT` (
`ID_` varchar(64) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`DEPLOY_TIME_` datetime DEFAULT NULL,
PRIMARY KEY (`ID_`)
);
CREATE TABLE `ACT_RE_PROCDEF` (
`ID_` varchar(64) NOT NULL,
`REV_` int(11) DEFAULT NULL,
`CATEGORY_` varchar(255) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`KEY_` varchar(255) DEFAULT NULL,
`VERSION_` int(11) DEFAULT NULL,
`DEPLOYMENT_ID_` varchar(64) DEFAULT NULL,
`RESOURCE_NAME_` varchar(4000) DEFAULT NULL,
`DGRM_RESOURCE_NAME_` varchar(4000) DEFAULT NULL,
`DESCRIPTION_` varchar(4000) DEFAULT NULL,
`HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL,
`HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL,
`SUSPENSION_STATE_` int(11) DEFAULT NULL,
`TENANT_ID_` varchar(255) DEFAULT '',
PRIMARY KEY (`ID_`),
KEY `ACT_IDX_PROCDEF_DEPLOYMENT` (`DEPLOYMENT_ID_`),
CONSTRAINT `ACT_FK_PROCDEF_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE `ACT_GE_BYTEARRAY` (
`ID_` varchar(64) NOT NULL,
`REV_` int(11) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`BYTES_` longblob,
`DEPLOYMENT_ID_` varchar(64) DEFAULT NULL,
`GENERATED_` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `ACT_IDX_BYTEARRAY_DEPLOYMENT` (`DEPLOYMENT_ID_`),
CONSTRAINT `ACT_FK_BYTEARR_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE `ACT_HI_ACTINST` (
`ID_` varchar(64) NOT NULL,
`PROC_DEF_ID_` varchar(64) DEFAULT NULL,
`PROC_INST_ID_` varchar(64) DEFAULT NULL,
`EXECUTION_ID_` varchar(64) DEFAULT NULL,
`ACT_ID_` varchar(255) DEFAULT NULL,
`TASK_ID_` varchar(64) DEFAULT NULL,
`CALL_PROC_INST_ID_` varchar(64) DEFAULT NULL,
`ACT_NAME_` varchar(255) DEFAULT NULL,
`ACT_TYPE_` varchar(255) DEFAULT NULL,
`ASSIGNEE_` varchar(255) DEFAULT NULL,
`START_TIME_` datetime DEFAULT NULL,
`END_TIME_` datetime DEFAULT NULL,
`DURATION_` bigint(20) DEFAULT NULL,
`DELETE_REASON_` varchar(4000) DEFAULT NULL,
`TENANT_ID_` varchar(255) DEFAULT '',
PRIMARY KEY (`ID_`),
KEY `ACT_IDX_HI_ACT_INST_PROC_INST` (`PROC_INST_ID_`),
KEY `ACT_IDX_HI_ACT_INST_EXECUTION` (`EXECUTION_ID_`),
KEY `ACT_IDX_HI_ACT_INST_TASK` (`TASK_ID_`),
CONSTRAINT `ACT_FK_HI_ACTINST_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_HI_PROCINST` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ACT_FK_HI_ACTINST_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_HI_ACTINST` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE `ACT_HI_PROCINST` (
`ID_` varchar(64) NOT NULL,
`PROC_DEF_ID_` varchar(64) DEFAULT NULL,
`BUSINESS_KEY_` varchar(255) DEFAULT NULL,
`START_TIME_` datetime DEFAULT NULL,
`END_TIME_` datetime DEFAULT NULL,
`DURATION_` bigint(20) DEFAULT NULL,
`START_USER_ID_` varchar(255) DEFAULT NULL,
`END_ACT_ID_` varchar(255) DEFAULT NULL,
`DELETE_REASON_` varchar(4000) DEFAULT NULL,
`SUPER_PROCESS_INSTANCE_ID_` varchar(64) DEFAULT NULL,
`TENANT_ID_` varchar(255) DEFAULT '',
PRIMARY KEY (`ID_`),
KEY `ACT_IDX_HI_PRO_INST_BUSKEY` (`BUSINESS_KEY_`),
KEY `ACT_IDX_HI_PROC_INST_START` (`START_TIME_`),
KEY `ACT_IDX_HI_PROC_INST_END` (`END_TIME_`),
KEY `ACT_IDX_HI_PROC_INST_SUPER` (`SUPER_PROCESS_INSTANCE_ID_`),
CONSTRAINT `ACT_FK_HI_PROCINST_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE `ACT_HI_TASKINST` (
`ID_` varchar(64) NOT NULL,
`PROC_DEF_ID_` varchar(64) DEFAULT NULL,
`TASK_DEF_KEY_` varchar(255) DEFAULT NULL,
`PROC_INST_ID_` varchar(64) DEFAULT NULL,
`EXECUTION_ID_` varchar(64) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`PARENT_TASK_ID_` varchar(64) DEFAULT NULL,
`DESCRIPTION_` varchar(4000) DEFAULT NULL,
`OWNER_` varchar(255) DEFAULT NULL,
`ASSIGNEE_` varchar(255) DEFAULT NULL,
`START_TIME_` datetime DEFAULT NULL,
`CLAIM_TIME_` datetime DEFAULT NULL,
`END_TIME_` datetime DEFAULT NULL,
`DURATION_` bigint(20) DEFAULT NULL,
`DELETE_REASON_` varchar(4000) DEFAULT NULL,
`PRIORITY_` int(11) DEFAULT NULL,
`DUE_DATE_` datetime DEFAULT NULL,
`FORM_KEY_` varchar(255) DEFAULT NULL,
`CATEGORY_` varchar(255) DEFAULT NULL,
`TENANT_ID_` varchar(255) DEFAULT '',
PRIMARY KEY (`ID_`),
KEY `ACT_IDX_HI_TASK_INST_PROC_DEF` (`PROC_DEF_ID_`),
KEY `ACT_IDX_HI_TASK_INST_PROC_INST` (`PROC_INST_ID_`),
KEY `ACT_IDX_HI_TASK_INST_EXEC` (`EXECUTION_ID_`),
KEY `ACT_IDX_HI_TASK_INST_DELETE` (`DELETE_REASON_`),
KEY `ACT_IDX_HI_TASK_INST_END` (`END_TIME_`),
KEY `ACT_IDX_HI_TASK_INST_NAME` (`NAME_`),
KEY `ACT_IDX_HI_TASK_INST_PRIORITY` (`PRIORITY_`),
CONSTRAINT `ACT_FK_HI_TASKINST_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_HI_PROCINST` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ACT_FK_HI_TASKINST_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ACT_FK_HI_TASKINST_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE `ACT_RU_EXECUTION` (
`ID_` varchar(64) NOT NULL,
`REV_` int(11) DEFAULT NULL,
`BUSINESS_KEY_` varchar(255) DEFAULT NULL,
`PROC_DEF_ID_` varchar(64) DEFAULT NULL,
`ACT_ID_` varchar(255) DEFAULT NULL,
`IS_ACTIVE_` tinyint(4) DEFAULT NULL,
`IS_CONCURRENT_` tinyint(4) DEFAULT NULL,
`IS_SCOPE_` tinyint(4) DEFAULT NULL,
`IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL,
`PARENT_ID_` varchar(64) DEFAULT NULL,
`SUPER_EXEC_` varchar(64) DEFAULT NULL,
`PROC_INST_ID_` varchar(64) DEFAULT NULL,
`ROOT_PROC_INST_ID_` varchar(64) DEFAULT NULL,
`REV_PARENT_TASK_` varchar(64) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`LOCK_TIME_` datetime DEFAULT NULL,
`IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL,
`SUSPENSION_STATE_` int(11) DEFAULT NULL,
`CACHED_ENT_STATE_` int(11) DEFAULT NULL,
`TENANT_ID_` varchar(255) DEFAULT '',
PRIMARY KEY (`ID_`),
KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
KEY `ACT_IDX_EXEC_PROCINST` (`PROC_INST_ID_`),
KEY `ACT_IDX_EXEC_SUPER` (`SUPER_EXEC_`),
KEY `ACT_IDX_EXEC_ROOT_PROC` (`ROOT_PROC_INST_ID_`),
KEY `ACT_IDX_EXEC_ACT` (`ACT_ID_`),
KEY `ACT_IDX_EXEC_PARENT` (`PARENT_ID_`),
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_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE `ACT_RU_TASK` (
`ID_` varchar(64) NOT NULL,
`REV_` int(11) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`PARENT_TASK_ID_` varchar(64) DEFAULT NULL,
`DESCRIPTION_` varchar(4000) DEFAULT NULL,
`TASK_DEF_KEY_` varchar(255) DEFAULT NULL,
`OWNER_` varchar(255) DEFAULT NULL,
`ASSIGNEE_` varchar(255) DEFAULT NULL,
`DELEGATION_` varchar(64) DEFAULT NULL,
`PRIORITY_` int(11) DEFAULT NULL,
`CREATE_TIME_` datetime DEFAULT NULL,
`DUE_DATE_` datetime DEFAULT NULL,
`CATEGORY_` varchar(255) DEFAULT NULL,
`SUSPENSION_STATE_` int(11) DEFAULT NULL,
`TENANT_ID_` varchar(255) DEFAULT '',
PRIMARY KEY (`ID_`),
KEY `ACT_IDX_TASK_PROCINST` (`PROC_INST_ID_`),
KEY `ACT_IDX_TASK_EXEC` (`EXECUTION_ID_`),
KEY `ACT_IDX_TASK_NAME` (`NAME_`),
KEY `ACT_IDX_TASK_ASSIGNEE` (`ASSIGNEE_`),
KEY `ACT_IDX_TASK_CREATE_TIME` (`CREATE_TIME_`),
KEY `ACT_IDX_TASK_OWNER` (`OWNER_`),
CONSTRAINT `ACT_FK_TASK_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ACT_FK_TASK_PARENT` FOREIGN KEY (`PARENT_TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE `ACT_GE_PROPERTY` (
`NAME_` varchar(64) NOT NULL,
`VALUE_` varchar(300) DEFAULT NULL,
`REV_` int(11) DEFAULT NULL,
PRIMARY KEY (`NAME_`)
);
```
3. 修改 activiti-explorer.war 文件下 WEB-INF/classes 目录下的 db.properties 文件,将其中的数据库配置改为:
```
db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti?useSSL=false&useUnicode=true&characterEncoding=utf-8&autoReconnect=true
jdbc.username=root
jdbc.password=root
```
其中,jdbc.url 中的数据库名应改为自己创建的数据库名称,jdbc.username 和 jdbc.password 应改为自己的数据库用户名和密码。
4. 启动 Tomcat 服务器,访问 http://localhost:8080/activiti-explorer 即可使用 activiti-explorer 示例工程。
activiti6的28张表注释
1. ACT_GE_PROPERTY:引擎属性表,存储引擎的核心属性
2. ACT_HI_ACTINST:所有活动实例的历史记录
3. ACT_HI_ATTACHMENT:附件表,存储任务实例的附加信息,如附件、批注等
4. ACT_HI_COMMENT:批注表,记录用户在任务上的批注信息
5. ACT_HI_DETAIL:详情表,存储活动实例的详细信息,例如变量、表单等
6. ACT_HI_IDENTITYLINK:身份关系表,存储参与者与任务之间的关系信息
7. ACT_HI_PROCINST:流程实例历史表,存储流程实例的历史记录
8. ACT_HI_TASKINST:任务实例历史表,存储任务实例的历史记录
9. ACT_HI_VARINST:变量实例历史表,存储流程实例中的变量历史记录
10. ACT_ID_GROUP:用户组表,存储用户组信息
11. ACT_ID_INFO:用户信息表,存储用户信息
12. ACT_ID_MEMBERSHIP:用户组关系表,存储用户与用户组的关系信息
13. ACT_ID_USER:用户表,存储用户信息
14. ACT_RE_DEPLOYMENT:流程部署表,记录已部署的流程定义信息
15. ACT_RE_MODEL:模型表,存储模型信息
16. ACT_RE_PROCDEF:流程定义表,存储流程定义的信息
17. ACT_RU_DEADLETTER_JOB:死信任务表,记录执行失败的定时任务
18. ACT_RU_EVENT_SUBSCR:事件订阅表,存储订阅的流程事件信息
19. ACT_RU_EXECUTION:流程执行表,存储流程执行信息
20. ACT_RU_EXT_TASK:扩展任务表,可用于任务扩展
21. ACT_RU_JOB:任务表,存储任务信息
22. ACT_RU_SUSPENDED_JOB:挂起任务表,记录挂起的任务
23. ACT_RU_TASK:任务表,存储任务信息
24. ACT_RU_VARIABLE:变量表,存储流程实例中使用的变量信息
25. ACT_RU_IDENTITYLINK:身份关系表,存储参与者与任务之间的关系信息
26. ACT_EVT_LOG:事件日志表,存储流程事件日志信息
27. ACT_GE_BYTEARRAY:字节数组表,存储各种文件信息
28. ACT_GE_SCHEMA:Schema表,引擎用于存储和更新关系数据库的MyBatis映射文件的表。