https://blog.csdn.net/weixin_42041788/article/details/104068365

 

-- bpmn文件定义的 <process id="orderNewWorKFlow" name="订单新装流程" isExecutable="true">
-- key = process id
SELECT * FROM ACT_RE_PROCDEF t WHERE t.key_ = 'orderNewWorKFlow';
-- 启动流程实例 3fea2390-2000-11eb-8621-0242ac150006
select * from ACT_RU_EXECUTION t WHERE t.PROC_INST_ID_ = '3fe9fc7f-2000-11eb-8621-0242ac150006'
and t.ACT_ID_ = 'TACHE00210001'; -- bpmn tast id

-- 流程定义被部署后 生成
select * from ACT_HI_ACTINST where PROC_INST_ID_ = '3fe9fc7f-2000-11eb-8621-0242ac150006'

-- 任务环节会变更 一个实例只有一条运行中任务
SELECT T.ASSIGNEE_,T.* FROM ACT_RU_TASK T WHERE
T.PROC_INST_ID_ = '3fe9fc7f-2000-11eb-8621-0242ac150006'; -- and T.TASK_DEF_KEY_ = 'TACHE00210001';
-- orderNewWorKFlow:1:13fbe63f-18d8-11eb-8621-0242ac150006

-- bpmn tack 里面的 delegateExpression 监听 任务执行人设置
-- 保存到了表
select * from ACT_RU_IDENTITYLINK t where t.TASK_ID_ = '5c01045f-2013-11eb-8621-0242ac150006';
-- his
select * from ACT_HI_IDENTITYLINK t where t.TASK_ID_ = '3fea2393-2000-11eb-8621-0242ac150006';