CREATE TABLE workflow_case_role_party_map ( case_id integer NOT NULL, role_id integer NOT NULL, party_id integer NOT NULL, PRIMARY KEY (case_id,role_id,party_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_role_pty_map_case_id_fk REFERENCES workflow_cases (), CONSTRAINT wf_case_role_pty_map_pk REFERENCES workflow_cases (), CONSTRAINT wf_case_role_pty_map_pty_id_fk REFERENCES workflow_cases (), CONSTRAINT wf_case_role_pty_map_role_id_fk REFERENCES workflow_cases () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_role_pty_map_role_id_fk REFERENCES parties (), CONSTRAINT wf_case_role_pty_map_pty_id_fk REFERENCES parties (), CONSTRAINT wf_case_role_pty_map_pk REFERENCES parties (), CONSTRAINT wf_case_role_pty_map_case_id_fk REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_role_pty_map_role_id_fk REFERENCES workflow_roles (), CONSTRAINT wf_case_role_pty_map_case_id_fk REFERENCES workflow_roles (), CONSTRAINT wf_case_role_pty_map_pk REFERENCES workflow_roles (), CONSTRAINT wf_case_role_pty_map_pty_id_fk REFERENCES workflow_roles () ); CREATE TRIGGER RI_ConstraintTrigger_c_343284 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343285 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343289 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343290 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343294 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343295 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 286,720 bytes -- Table rows: 6,439
Begin main content
