-- -- When part of the output of one task is to assign users to a role, -- specify that this is the case by inserting a row here. -- CREATE TABLE wf_transition_role_assign_map ( workflow_key varchar(100) NOT NULL, -- -- transition_key is the assigning transition. -- transition_key varchar(100) NOT NULL, -- -- assign_role_key is the role being assigned a user to. -- assign_role_key varchar(100) NOT NULL, PRIMARY KEY (workflow_key,transition_key,assign_role_key), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_role_asgn_map_pk REFERENCES wf_transitions (), CONSTRAINT wf_role_asgn_map_trans_fk REFERENCES wf_transitions (), CONSTRAINT wf_role_asgn_map_workflow_fk REFERENCES wf_transitions (), CONSTRAINT wf_tr_role_asgn_map_asgn_fk REFERENCES wf_transitions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_tr_role_asgn_map_asgn_fk REFERENCES wf_workflows (), CONSTRAINT wf_role_asgn_map_workflow_fk REFERENCES wf_workflows (), CONSTRAINT wf_role_asgn_map_trans_fk REFERENCES wf_workflows (), CONSTRAINT wf_role_asgn_map_pk REFERENCES wf_workflows () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_tr_role_asgn_map_asgn_fk REFERENCES wf_roles (), CONSTRAINT wf_role_asgn_map_pk REFERENCES wf_roles (), CONSTRAINT wf_role_asgn_map_trans_fk REFERENCES wf_roles (), CONSTRAINT wf_role_asgn_map_workflow_fk REFERENCES wf_roles () ); CREATE INDEX wf_role_asgn_map_wf_as_tr_idx ON wf_transition_role_assign_map (workflow_key, assign_role_key); CREATE INDEX wf_role_asgn_map_wf_trans_idx ON wf_transition_role_assign_map (workflow_key, transition_key); CREATE TRIGGER RI_ConstraintTrigger_c_343464 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343465 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343469 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343470 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343574 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343575 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 1
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: wf_transition_role_assign_map
Begin main content
