?????????????????

???????????????￡?

????1)????????????S_flow_info(flow_id??flow_name)

????2)????????????S_action_info(action_id??action_name)

????3)??????-??????????S_step_info(step_id??action_id??flow_id??step_repeat_no??step_order_no??step_type)

????(????step_repeat_no??????????step_order_no???????step_type??????0????1?????)

????4)???????????????L_tranct_proc(proc_id??loan_id??step_id??step_action??step_emp_id)

????(????loan_id???????????????step_id????S_action_info??step_action

?????洢????????0--???????1--?????2--????3--?????4--?????step_emp_id??????????????)

????????????????????????????????????????????????????????????????????塣?????????????????????????????????????????????????

?????????????????

????1)??????????L_loan_info(loan_id??loan_name??flow_id??step_id??...)

????(flow_id????????step_id????S_action_info)

????2)???????????E_emp_info(emp_id??emp_name??..)

????3)??????????E_role_info(role_id??role_name)

????4)?????-????????E_emp_role(emp_role_id??emp_id??role_id)

????(????????????????)

????5)?????????????S_action_role(action_role_id??action_id??role_id)

????(??????????????)

????6)????????????L_loan_next_emp(loan_next_emp_id??loan_id??next_emp_id??step_id)

????(????next_emp_id?????????????E_emp_info??step_id????S_action_info)

???????????????????￡?

????1)???????????????????L_loan_info???????????step_id???????????????????????????????????????????????????????????????????????????????L_loan_next_emp??;???????????????????????step_id??????????;???????? L_loan_info??step_id??????????;

????2)??????????????;

????3)????????????????????????(??????????????????)????????д????????????(0?????????1???????2??????3?????)?????????????????У????????????????L_loan_info??step_id???????????????????????????????????μ????????????;

????4)???????????????п?????????????????????????в????????н??в???????????????????г?????????????????(4??????)?????????????????У????е?next_emp_id??????????????);????????L_loan_info??step_id???????????????;

????5)????????????3)??4)??????????????????;

????6)???????????裬??????????step_id??0?????????????????С?