CREATE TABLE workflow_action_allowed_roles ( action_id integer NOT NULL, role_id integer NOT NULL, PRIMARY KEY (action_id,role_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_acn_alwd_roles_acn_id_fk REFERENCES workflow_actions (), CONSTRAINT wf_acn_alwd_roles_pk REFERENCES workflow_actions (), CONSTRAINT wf_acn_alwd_roles_role_id_fk REFERENCES workflow_actions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_acn_alwd_roles_role_id_fk REFERENCES workflow_roles (), CONSTRAINT wf_acn_alwd_roles_acn_id_fk REFERENCES workflow_roles (), CONSTRAINT wf_acn_alwd_roles_pk REFERENCES workflow_roles () ); CREATE TRIGGER RI_ConstraintTrigger_c_343124 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343125 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343129 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343130 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 28
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: workflow_action_allowed_roles
Begin main content
