流程--对应节点ID 表及sql

相关表

Workflow_base流程定义表

workflow_requestbase 请求信息表，

workflow_flownode 节点信息表，

workflow_nodebase 节点基础信息表

workflow_currentoperator流程当前操作人表

---

select startnodeid,*

from workflow_nodebase --节点基础信息表

select *

from workflow_flownode

where workflowid=111--节点信息表

select currentnodetype,CURRENTNODEID, *

from workflow_requestbase

where workflowid=111

select workflowid,nodeid,nodename,*

from workflow_flownode

left join workflow_nodebase

on workflow_flownode.nodeid=workflow_nodebase.id

where workflowid=111

============================================

--分公司

select id,*

from workflow_nodebase

where nodename like '%分部总经理%' and ID=788

select workflowid,nodeid,*

from workflow_flownode

where nodeid=491

select id,*

from Workflow_base

where id=154

select Workflow_base.id,Workflow_base.workflowname,*

from workflow_nodebase

left join workflow_flownode on workflow_nodebase.id=workflow_flownode.nodeid

left join Workflow_base on workflow_flownode.workflowid=Workflow_base.id

where nodename like '%公司负责人%'