-- -- This table holds context-dependent info for roles, currently only the assignment callback -- CREATE TABLE wf_context_role_info ( context_key varchar(100) NOT NULL, workflow_key varchar(100) NOT NULL, role_key varchar(100) NOT NULL, assignment_callback varchar(100), assignment_custom_arg varchar(4000), PRIMARY KEY (context_key,workflow_key,role_key), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_role_context_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_role_info_pk REFERENCES wf_contexts (), CONSTRAINT wf_context_role_role_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_role_workflow_fk REFERENCES wf_contexts () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_role_workflow_fk REFERENCES wf_roles (), CONSTRAINT wf_context_role_role_fk REFERENCES wf_roles (), CONSTRAINT wf_context_role_info_pk REFERENCES wf_roles (), CONSTRAINT wf_context_role_context_fk REFERENCES wf_roles () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_role_workflow_fk REFERENCES wf_workflows (), CONSTRAINT wf_context_role_context_fk REFERENCES wf_workflows (), CONSTRAINT wf_context_role_info_pk REFERENCES wf_workflows (), CONSTRAINT wf_context_role_role_fk REFERENCES wf_workflows () ); CREATE TRIGGER RI_ConstraintTrigger_c_343374 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343375 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343379 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343380 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343384 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343385 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
