CREATE TABLE workflow_cases ( case_id integer PRIMARY KEY NOT NULL, workflow_id integer NOT NULL, object_id integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_cases_object_id_fk REFERENCES acs_objects (), CONSTRAINT wf_cases_workflow_id_fk REFERENCES acs_objects (), CONSTRAINT workflow_cases_pk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT workflow_cases_pk REFERENCES workflows (), CONSTRAINT wf_cases_object_id_fk REFERENCES workflows (), CONSTRAINT wf_cases_workflow_id_fk REFERENCES workflows () ); CREATE INDEX workflow_cases_object_id_idx ON workflow_cases (object_id); CREATE INDEX workflow_cases_workflow_id ON workflow_cases (workflow_id); CREATE TRIGGER RI_ConstraintTrigger_a_343237 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343238 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343252 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343253 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343267 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343268 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343282 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343283 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343314 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343315 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343324 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343325 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to workflow_cases: --workflow_case_enabled_actions(wf_cases_object_id_fk) --workflow_case_enabled_actions(wf_cases_workflow_id_fk) --workflow_case_enabled_actions(workflow_cases_pk) --workflow_case_fsm(wf_cases_object_id_fk) --workflow_case_fsm(wf_cases_workflow_id_fk) --workflow_case_fsm(workflow_cases_pk) --workflow_case_log(wf_cases_object_id_fk) --workflow_case_log(wf_cases_workflow_id_fk) --workflow_case_log(workflow_cases_pk) --workflow_case_role_party_map(wf_cases_object_id_fk) --workflow_case_role_party_map(wf_cases_workflow_id_fk) --workflow_case_role_party_map(workflow_cases_pk) -- Table size: 163,840 bytes -- Table rows: 3,621
Begin main content
