CREATE TABLE workflow_case_action_assignees ( enabled_action_id integer NOT NULL, party_id integer NOT NULL, PRIMARY KEY (enabled_action_id,party_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_action_assignees_pk REFERENCES workflow_case_enabled_actions (), CONSTRAINT wf_case_actn_asgn_enbld_actn_fk REFERENCES workflow_case_enabled_actions (), CONSTRAINT wf_case_actn_asgn_party_id_fk REFERENCES workflow_case_enabled_actions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_actn_asgn_party_id_fk REFERENCES parties (), CONSTRAINT wf_case_action_assignees_pk REFERENCES parties (), CONSTRAINT wf_case_actn_asgn_enbld_actn_fk REFERENCES parties () ); CREATE INDEX wf_case_actn_asgn_en_act_idx ON workflow_case_action_assignees (enabled_action_id); CREATE INDEX wf_case_actn_asgn_party_idx ON workflow_case_action_assignees (party_id); CREATE TRIGGER RI_ConstraintTrigger_c_343199 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343200 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343204 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343205 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: workflow_case_action_assignees
Begin main content
