-- -- Manual per-case assignments of roles to parties. -- CREATE TABLE wf_case_assignments ( case_id integer NOT NULL, workflow_key varchar(100), role_key varchar(100) NOT NULL, party_id integer NOT NULL, PRIMARY KEY (case_id,role_key,party_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_assign_fk REFERENCES wf_cases (), CONSTRAINT wf_case_assign_party_fk REFERENCES wf_cases (), CONSTRAINT wf_case_assign_pk REFERENCES wf_cases (), CONSTRAINT wf_case_assign_role_fk REFERENCES wf_cases () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_assign_role_fk REFERENCES parties (), CONSTRAINT wf_case_assign_pk REFERENCES parties (), CONSTRAINT wf_case_assign_party_fk REFERENCES parties (), CONSTRAINT wf_case_assign_fk REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_assign_role_fk REFERENCES wf_roles (), CONSTRAINT wf_case_assign_fk REFERENCES wf_roles (), CONSTRAINT wf_case_assign_party_fk REFERENCES wf_roles (), CONSTRAINT wf_case_assign_pk REFERENCES wf_roles () ); CREATE INDEX wf_case_assgn_party_idx ON wf_case_assignments (party_id); CREATE TRIGGER RI_ConstraintTrigger_c_343209 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343210 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343214 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343215 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343219 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343220 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
