Activiti待办相关表

 

select * from act_hi_detail where TEXT_='ZN00254'

 

select * from act_ru_execution where BUSINESS_KEY_ like '%1b798068e3814ca98d5a3bacf0a8b0d9%'

select * from act_hi_procinst where BUSINESS_KEY_ like '%1b798068e3814ca98d5a3bacf0a8b0d9%'

select * from act_hi_taskinst where PROC_INST_ID_='78cea5681a2a4bd59e29ffc42e704ec1'

select * from act_ru_task where PROC_DEF_ID_='process:38:f03d8244b9f64267806444112e9b52f8'

select * from act_hi_identitylink where PROC_INST_ID_='78cea5681a2a4bd59e29ffc42e704ec1'

select *from act_hi_taskinst where PROC_INST_ID_='78cea5681a2a4bd59e29ffc42e704ec1'

select * from act_ru_identitylink where PROC_INST_ID_='78cea5681a2a4bd59e29ffc42e704ec1'

select * from act_hi_actinst where PROC_INST_ID_='78cea5681a2a4bd59e29ffc42e704ec1'

select * from sys_user w where login_name='fengguojing';

 

 

 

 

 

select * from act_ru_execution where BUSINESS_KEY_ like '%904af19cd51940b298370a3045a28597%'

select * from act_hi_procinst where START_USER_ID_ ='ZN00254'

select * from act_hi_taskinst where ASSIGNEE_='ZN00254'

select * from act_ru_task where ASSIGNEE_='ZN00254'

select * from act_hi_identitylink where USER_ID_='ZN00254'

select *from act_hi_taskinst where ASSIGNEE_='ZN00254'

select * from act_ru_identitylink where USER_ID_='ZN00254'

select * from act_hi_actinst where ASSIGNEE_='ZN00254'