一般数据 (ACT_GE_)
select * from act_ge_bytearray;
select * from act_ge_property;
流程定义表(act_re_)
select * from act_re_deployment;
select * from act_re_model;
select * from act_re_procdef;
运行实例表(act_ru_)
select * from act_ru_task;
select * from act_ru_execution;
select * from act_ru_identitylink;
select * from act_ru_job;
select * from act_ru_variable;
select * from act_ru_event_subscr;
SELECT TASK.Id_, TASK.Name_, EXECUTION.Parent_Id_ , TASK.Proc_Inst_Id_, TASK.Assignee_, EXECUTION.Business_Key_
FROM ACT_RU_TASK TASK, ACT_RU_EXECUTION EXECUTION
WHERE TASK.PROC_INST_ID_ = EXECUTION.Proc_Inst_Id_ AND EXECUTION.Parent_Id_ IS NULL
流程历史记录(act_hi_)
select * from act_hi_taskinst;
select * from act_hi_procinst;
select * from act_hi_actinst;
select * from act_hi_attachment;
select * from act_hi_comment;
select * from act_hi_detail;
select * from act_hi_identitylink;
select * from act_hi_varinst;
其他
select * from act_evt_log;
select * from act_procdef_info
select * from act_re_deployment;
SELECT * FROM act_re_procdef;
select * from act_ge_bytearray;
SELECT * FROM ACT_RU_TASK;
SELECT * FROM ACT_HI_TASKINST;
SELECT * FROM act_ru_execution;
SELECT * FROM act_ru_variable;
SELECT * FROM act_hi_varinst;
select * from act_ru_task a
left join act_ru_identitylink b on a.id_ = b.task_id_
where a.id_ = '8c567206-f1a3-11ea-b045-e8d0fcea6c62'