重要的数据表

Survive by day and develop by night.
talk for import biz , show your perfect code,full busy，skip hardness,make a better result,wait for change,challenge Survive.
happy for hardess to solve denpendies.

目录

概述

重要的数据表

需求：

设计思路

实现思路分析

1.-- 组织结构数据库.

SELECT * FROM Port_Emp; --用户
SELECT * FROM Port_Dept; --部门.
SELECT * FROM Port_DeptEmp; --部门人员对应.
SELECT * FROM Port_DeptEmpStation; --部门人员岗位.
SELECT * FROM Port_StationType; --岗位类型。
SELECT * FROM Port_Station; – 岗位.
SELECT * FROM Port_Org; – 组织.
SELECT * FROM Port_OrgAdminer; --管理员.

– 流程模版.
SELECT * FROM WF_Flow WHERE No=‘010’; --流程属性.
SELECT * FROM WF_Node WHERE FK_Flow=‘010’; --节点属性.
SELECT * FROM WF_Direction WHERE FK_Flow=‘010’; – 连接线.
SELECT * FROM WF_LabNote WHERE FK_Flow=‘010’; --备注信息.
SELECT * FROM WF_Cond WHERE FK_Flow=‘010’; --方向条件.

– 流程数据表.
SELECT * FROM ND10Rpt WHERE OID=120; --流程数据表. 表自动生成.
SELECT * FROM ND10Track WHERE WorkID=120 ORDER BY RDT; --轨迹表.

– 流程引擎表.
SELECT * FROM WF_GenerWorkFlow WHERE WorkID=121; --流程引擎注册表, 主键WorkID
SELECT * FROM WF_GenerWorkerlist WHERE WorkID=121; --工作人员表.主键 WorkID,FK_Emp,FK_Node.
SELECT * FROM Sys_Enum WHERE EnumKey=‘WFState’ – 流程状态枚举.

– 求待办的视图
SELECT A.WorkID, A.Title, a.FK_Flow, a.FK_Node , a.NodeName , b.FK_Emp
FROM WF_GenerWorkFlow A, WF_GenerWorkerlist B
WHERE A.WorkID=B.WorkID AND A.FK_Node=B.FK_Node AND B.IsPass=0

– 求在途的视图
SELECT a.Title, A.WorkID, a.FK_Node,a.NodeName FROM WF_GenerWorkFlow A, WF_GenerWorkerlist B

WHERE A.WorkID=B.WorkID and B.FK_Emp=‘liping’ and B.IsPass=1

– 综合查询SQL
select * from WF_GenerWorkFlow where fk_dept=‘1001’ --综合查询.
select * from WF_GenerWorkFlow where Starter=‘zhangsan’ --查询zhangsan发起的流程.

– 表单模版
SELECT * FROM Sys_MapData WHERE No=‘ND1001’; --模版注册表.
SELECT * FROM Sys_MapAttr WHERE FK_MapData=‘ND1001’; – 字段表.
SELECT * FROM Sys_MapDtl WHERE FK_MapData=‘ND1001’; --从(子)表
SELECT * FROM Sys_MapAttr WHERE FK_MapData =‘ND1001Dtl1’ – 从(子)表的字段.
SELECT * FROM Sys_GroupField WHERE FrmID=‘ND1001’; --分组列表.
SELECT * FROM Sys_MapExt WHERE FK_MapData=‘ND1001’; --业务逻辑

参考资料和推荐阅读

1.暂无
https://gitee.com/opencc/JFlow/wikis/%E6%B5%81%E7%A8%8B%E8%AE%B2%E4%B9%89/%E5%B7%A5%E4%BD%9C%E6%B5%81%E5%9F%BA%E7%A1%80/%E9%87%8D%E8%A6%81%E7%9A%84%E6%95%B0%E6%8D%AE%E8%A1%A8

欢迎阅读，各位老铁，如果对你有帮助，点个赞加个关注呗！~