CREATE TABLE workflow_case_enabled_actions ( enabled_action_id integer PRIMARY KEY NOT NULL, case_id integer NOT NULL, action_id integer NOT NULL, parent_enabled_action_id integer, assigned_p bool DEFAULT false, completed_p bool DEFAULT false, execution_time timestamptz, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_enbl_act_action_id_fk REFERENCES workflow_actions (), CONSTRAINT wf_case_enbl_act_case_id_fk REFERENCES workflow_actions (), CONSTRAINT wf_case_enbl_act_case_id_pk REFERENCES workflow_actions (), CONSTRAINT wf_case_enbl_act_parent_id_fk REFERENCES workflow_actions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_enbl_act_parent_id_fk REFERENCES workflow_cases (), CONSTRAINT wf_case_enbl_act_case_id_pk REFERENCES workflow_cases (), CONSTRAINT wf_case_enbl_act_case_id_fk REFERENCES workflow_cases (), CONSTRAINT wf_case_enbl_act_action_id_fk REFERENCES workflow_cases () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_enbl_act_parent_id_fk REFERENCES workflow_case_enabled_actions (), CONSTRAINT wf_case_enbl_act_action_id_fk REFERENCES workflow_case_enabled_actions (), CONSTRAINT wf_case_enbl_act_case_id_fk REFERENCES workflow_case_enabled_actions (), CONSTRAINT wf_case_enbl_act_case_id_pk REFERENCES workflow_case_enabled_actions () ); CREATE INDEX wf_case_enbl_act_action_idx ON workflow_case_enabled_actions (action_id); CREATE INDEX wf_case_enbl_act_case_idx ON workflow_case_enabled_actions (case_id); CREATE INDEX wf_case_enbl_act_parent_idx ON workflow_case_enabled_actions (parent_enabled_action_id); CREATE TRIGGER RI_ConstraintTrigger_a_343197 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343198 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343234 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343235 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343239 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343240 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343242 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343243 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343244 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343245 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343247 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343248 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to workflow_case_enabled_actions: --workflow_case_action_assignees(wf_case_enbl_act_action_id_fk) --workflow_case_action_assignees(wf_case_enbl_act_case_id_fk) --workflow_case_action_assignees(wf_case_enbl_act_case_id_pk) --workflow_case_action_assignees(wf_case_enbl_act_parent_id_fk) --workflow_case_enabled_actions(wf_case_enbl_act_action_id_fk) --workflow_case_enabled_actions(wf_case_enbl_act_case_id_fk) --workflow_case_enabled_actions(wf_case_enbl_act_case_id_pk) --workflow_case_enabled_actions(wf_case_enbl_act_parent_id_fk) --workflow_case_fsm(wf_case_enbl_act_action_id_fk) --workflow_case_fsm(wf_case_enbl_act_case_id_fk) --workflow_case_fsm(wf_case_enbl_act_case_id_pk) --workflow_case_fsm(wf_case_enbl_act_parent_id_fk) -- Table size: 638,976 bytes -- Table rows: 14,408
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: workflow_case_enabled_actions
Begin main content
