平台审批的几张表以及关系

select * from WORKITEM LEFT JOIN PROCESSINSTANCE ON WORKITEM.PROCESSDEFINITIONID=PROCESSINSTANCE.PROCESSDEFINITIONID LEFT JOIN SZYDHYB ON SZYDHYB_LCNM=PROCESSINSTANCE.PROCESSINSTANCEID where WORKITEM.STATE=2
AND PARTICIPANT ='zhaodachun@hq.cmcc'
AND SZYDHYB_HYMC='2020第0019次经理层办公会' order by WORKITEM.STARTEDDATE DESC

PROCESSINSTANCE

BIZLOG