-- -- A process has certain roles associated with it, such as "submitter", -- "reviewer", "editor", "claimant", etc. For each transition, then, you -- specify what role is to perform that task. Thus, two or more tasks can be -- performed by one and the same role, so that when the role is reassigned, -- it reflects assignments of both tasks. Users and parties are then assigned -- to roles instead of directly to tasks. -- CREATE TABLE wf_roles ( role_key varchar(100) NOT NULL, workflow_key varchar(100) NOT NULL, role_name varchar(100) NOT NULL, sort_order integer, PRIMARY KEY (role_key,workflow_key), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_role_pk REFERENCES wf_workflows (), CONSTRAINT wf_roles_workflow_fk REFERENCES wf_workflows (), CONSTRAINT wf_roles_order_ck REFERENCES wf_workflows () ); CREATE UNIQUE INDEX wf_roles_wf_key_role_name_un ON wf_roles (workflow_key, role_name); CREATE TRIGGER RI_ConstraintTrigger_a_343217 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343218 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343347 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343348 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343377 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343378 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343494 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343495 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343572 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343573 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343592 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343593 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to wf_roles: --wf_case_assignments(wf_role_pk) --wf_case_assignments(wf_roles_order_ck) --wf_case_assignments(wf_roles_workflow_fk) --wf_context_assignments(wf_role_pk) --wf_context_assignments(wf_roles_order_ck) --wf_context_assignments(wf_roles_workflow_fk) --wf_context_role_info(wf_role_pk) --wf_context_role_info(wf_roles_order_ck) --wf_context_role_info(wf_roles_workflow_fk) --wf_transition_role_assign_map(wf_role_pk) --wf_transition_role_assign_map(wf_roles_order_ck) --wf_transition_role_assign_map(wf_roles_workflow_fk) --wf_transitions(wf_role_pk) --wf_transitions(wf_roles_order_ck) --wf_transitions(wf_roles_workflow_fk) -- Table size: 8,192 bytes -- Table rows: 2
Begin main content
