-- -- Static (default) per-context assignments of roles to parties. -- CREATE TABLE wf_context_assignments ( context_key varchar(100) NOT NULL, workflow_key varchar(100) NOT NULL, role_key varchar(100) NOT NULL, party_id integer NOT NULL, PRIMARY KEY (context_key,workflow_key,role_key,party_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_assign_party_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_assign_pk REFERENCES wf_contexts (), CONSTRAINT wf_context_assign_workflow_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_assign_context_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_assign_role_fk REFERENCES wf_contexts () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_assign_pk REFERENCES parties (), CONSTRAINT wf_context_assign_context_fk REFERENCES parties (), CONSTRAINT wf_context_assign_party_fk REFERENCES parties (), CONSTRAINT wf_context_assign_role_fk REFERENCES parties (), CONSTRAINT wf_context_assign_workflow_fk REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_assign_workflow_fk REFERENCES wf_roles (), CONSTRAINT wf_context_assign_role_fk REFERENCES wf_roles (), CONSTRAINT wf_context_assign_pk REFERENCES wf_roles (), CONSTRAINT wf_context_assign_party_fk REFERENCES wf_roles (), CONSTRAINT wf_context_assign_context_fk REFERENCES wf_roles () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_assign_workflow_fk REFERENCES wf_workflows (), CONSTRAINT wf_context_assign_context_fk REFERENCES wf_workflows (), CONSTRAINT wf_context_assign_party_fk REFERENCES wf_workflows (), CONSTRAINT wf_context_assign_pk REFERENCES wf_workflows (), CONSTRAINT wf_context_assign_role_fk REFERENCES wf_workflows () ); CREATE INDEX wf_ctx_assg_workflow_trans_idx ON wf_context_assignments (workflow_key, role_key); CREATE TRIGGER RI_ConstraintTrigger_c_343339 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343340 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343344 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343345 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343349 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343350 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343354 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343355 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
