-- -- The squares in the petri net. The things that somebody (or something) actually does. -- CREATE TABLE wf_transitions ( transition_key varchar(100) NOT NULL, transition_name varchar(100) NOT NULL, workflow_key varchar(100) NOT NULL, role_key varchar(100), sort_order integer, trigger_type varchar(40), PRIMARY KEY (transition_key,workflow_key), CONSTRAINT wf_transition_order_ck REFERENCES wf_roles (), CONSTRAINT wf_transition_pk REFERENCES wf_roles (), CONSTRAINT wf_transition_role_fk REFERENCES wf_roles (), CONSTRAINT wf_transition_trigger_type_ck REFERENCES wf_roles (), CONSTRAINT wf_transition_workflow_fk REFERENCES wf_roles () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_transition_workflow_fk REFERENCES wf_workflows (), CONSTRAINT wf_transition_order_ck REFERENCES wf_workflows (), CONSTRAINT wf_transition_pk REFERENCES wf_workflows (), CONSTRAINT wf_transition_role_fk REFERENCES wf_workflows (), CONSTRAINT wf_transition_trigger_type_ck REFERENCES wf_workflows () ); CREATE UNIQUE INDEX wf_trans_wf_key_trans_name_un ON wf_transitions (workflow_key, transition_name); CREATE TRIGGER RI_ConstraintTrigger_a_343172 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343173 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343227 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343228 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343362 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343363 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343392 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343393 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343462 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343463 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343522 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343523 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343582 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343583 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343594 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343595 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343599 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343600 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to wf_transitions: --wf_arcs(wf_transition_order_ck) --wf_arcs(wf_transition_pk) --wf_arcs(wf_transition_role_fk) --wf_arcs(wf_transition_trigger_type_ck) --wf_arcs(wf_transition_workflow_fk) --wf_case_deadlines(wf_transition_order_ck) --wf_case_deadlines(wf_transition_pk) --wf_case_deadlines(wf_transition_role_fk) --wf_case_deadlines(wf_transition_trigger_type_ck) --wf_case_deadlines(wf_transition_workflow_fk) --wf_context_task_panels(wf_transition_order_ck) --wf_context_task_panels(wf_transition_pk) --wf_context_task_panels(wf_transition_role_fk) --wf_context_task_panels(wf_transition_trigger_type_ck) --wf_context_task_panels(wf_transition_workflow_fk) --wf_context_transition_info(wf_transition_order_ck) --wf_context_transition_info(wf_transition_pk) --wf_context_transition_info(wf_transition_role_fk) --wf_context_transition_info(wf_transition_trigger_type_ck) --wf_context_transition_info(wf_transition_workflow_fk) --wf_tasks(wf_transition_order_ck) --wf_tasks(wf_transition_pk) --wf_tasks(wf_transition_role_fk) --wf_tasks(wf_transition_trigger_type_ck) --wf_tasks(wf_transition_workflow_fk) --wf_transition_attribute_map(wf_transition_order_ck) --wf_transition_attribute_map(wf_transition_pk) --wf_transition_attribute_map(wf_transition_role_fk) --wf_transition_attribute_map(wf_transition_trigger_type_ck) --wf_transition_attribute_map(wf_transition_workflow_fk) --wf_transition_role_assign_map(wf_transition_order_ck) --wf_transition_role_assign_map(wf_transition_pk) --wf_transition_role_assign_map(wf_transition_role_fk) --wf_transition_role_assign_map(wf_transition_trigger_type_ck) --wf_transition_role_assign_map(wf_transition_workflow_fk) -- Table size: 8,192 bytes -- Table rows: 4
Begin main content
