2024年4月12日发(作者：)

HrmResource 人力资源表 HrmDepartment 部门

workflow_base 所有流程工作流表

Workflow_requestbase 工作流，流水表

[formtable_main_176]表单存储表——请假申请

Workflow_form 工作流和表单关系表

workflow_billfield 表单的字段内容

索引：

Workflow_requestbase

workflow_billfield

workflow_currentoperator

HrmRefuseAvg

WorkPlan——无明显效果

DocDetail

DocDetailLog

WorkPlanShareDetail

Task_operateLog

SysPoppupRemindInfoNew

shareinnerdoc

Workflow_requestbase：该表存放了流程的基本信息：标题，创建人，创建时间，

流程类型

Workflow_form:该表存储了流程的具体信息通过REQUESTID字段和

Workflow_requestbase表关联(billid,billformid)

如何查字段名称?

select ame,ame from workflow_billfield b

left join HtmlLabelInfo h on abel=d

临时查询语句：

select * from workflow_nodebase

select * from workflow_nodelink where workflowid=37

select * from workflow_base where workflowname like '%工作联络函%'

id=37

nodeid 当前节点id destnodeid 下一节点id

select * from Workflow_requestbase

where createdate='2016-06-24'

and workflowid=37

and requestname like '111111'

select fieldid,selectvalue,selectname from workflow_SelectItem

where fieldid= '9315' and selectvalue='0'

select * from workflow_base where workflowname like '%%' 235

select * from workflow_billfield

where fieldname like 'yglzwslc009' 9315