审批关系表

PathInfo(审批线路)

IDXFlowID(int)PathName(varchar)PathStartID(int)PathEndID(int)...

ApprovalRefInfo(审批人员)

IDX(int)PathID(int)UserID(int)DeptID(int) ......

IDX: AddrovalID1: N

ApprovalInfo(审批节点信息)

IDX(int)BussinessID(int)BussinessCode(varchar)SystemBussinessCode(varchar)FlowId(int) CurrentPathID(int)......

BusinessConfigInfo(审批业务配置)

IDX(int)BusinessCode(varchar)BusinessName(varchar)......

OrderId(订单表)

IDX(int)OrderID(int)......

IDX: PathID1: N

IDX: CurrentPathID1: N

IDX: BusinessConfigID1: N

OrderID: SystemBusinessCode1:1

ApprovalLogInfo(审批记录)

IDX(int)ApprovalID(int)PathID(int)UserID(int)DeptID(int) ......

FlowInfo(审批流程)

IDX(int)FlowName(varchar)CompanyId(int)BusinessConfigID(int) ......

IDX: FlowID1:N