Process Flow sheet, field [Id, Name]
FlowDetail process details table field [Id, FlowId, Type SortId] FlowId is Flow Id, SortId is sequence Id, through sorting, in turn, find audit process node
FlowCheckUserInfo process audit staff table field [FlowDetailId, UserId]
FlowCheckInfo process audit record field [FlowId FlowDetailId, User, Status, remark] Status "" 0 means audit failure, 1 audit success
Order orders table field [Id, FlowId, BillNo]

Relationship is this: a process have N process details, details of a process may be N for examination and approval, if read my order table data pushed to it should audit staff?

CodePudding user response:

Mark fields and use extraction solution
Reviewers 1, for example, to a ywshenhe fields, the default value is no, ywshry default is empty, the personnel 1, after checking ywshenhe field is, the update ywshry usernamew value, and then into the next step, ywshehe2 defaults to no, ywshry2 default is empty, add judgment conditions where ywshenhe='is' and ywshry is not null and ywshenhe2=' no ', behind the process and so on