select * from cmcs3_process_user_group;
select * from cmcs3_process p where p.processid = 1001;
select * from cmcs3_process_task_user u where u.usergroupid = 1020;
select * from cmcs3_process_task ;
select u.actors,ug.id from cmcs3_process p,cmcs3_process_user_group ug,cmcs3_process_task_user u,cmcs3_process_task t
where p.processid = ug.processid and ug.id = u.usergroupid and u.processtaskid = t.processtaskid
and t.taskname = '复核' and p.uniquecode = 'ExternalPayments' and ug.id = ?;
commit;
select * from cmcs3_process_instance_info
select * from jbpm_pooledactor
select * from jbpm_taskinstance
select * from jbpm_moduleinstance
--先通过流程id 找到对应的TaskInstance表,然后关联到 cmcs3_process_task,然后再通过processid关联cmcs3_process_user_group表
--这样就通过流程ID找到流程组了
--ProcessInstanceInfo id 是在JbpmProcessDaoImpl startProcess方法中 processInfor.setProcessInstanceId(id);
--同时又将 transferBill.setProcessInstanceID(processInstanceID),所以这两张表可以通过这个字段管理
=====角色表=====
select * from cmcs3_user u
where u.username = 'lhj2';
select ru.roleid from cmcs3_role_user ru
where ru.userid = 1580;
select * from cmcs3_role r
where r.roleid in (1000 ,1001 ,1003);
select * from cmcs3_role_history rh
where rh.roleid in (1000 ,1001 ,1003);
--JBPM相关表
select * from CMCS3_PROCESS_TASK;
select * from jbpm_TASK;
select * from CMCS3_PROCESS_USER_GROUP;
select * from CMCS3_PROCESS_TASK_USER;