CREATE TABLE workflow_case_fsm ( case_id integer NOT NULL, parent_enabled_action_id integer, current_state integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_fsm_action_id_fk REFERENCES workflow_case_enabled_actions (), CONSTRAINT wf_case_fsm_case_id_fk REFERENCES workflow_case_enabled_actions (), CONSTRAINT wf_case_fsm_case_parent_un REFERENCES workflow_case_enabled_actions (), CONSTRAINT wf_case_fsm_st_id_fk REFERENCES workflow_case_enabled_actions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_fsm_st_id_fk REFERENCES workflow_cases (), CONSTRAINT wf_case_fsm_case_parent_un REFERENCES workflow_cases (), CONSTRAINT wf_case_fsm_case_id_fk REFERENCES workflow_cases (), CONSTRAINT wf_case_fsm_action_id_fk REFERENCES workflow_cases () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_fsm_st_id_fk REFERENCES workflow_fsm_states (), CONSTRAINT wf_case_fsm_action_id_fk REFERENCES workflow_fsm_states (), CONSTRAINT wf_case_fsm_case_id_fk REFERENCES workflow_fsm_states (), CONSTRAINT wf_case_fsm_case_parent_un REFERENCES workflow_fsm_states () ); CREATE UNIQUE INDEX wf_case_fsm_case_parent_un ON workflow_case_fsm (case_id, parent_enabled_action_id); CREATE INDEX wf_case_fsm_prnt_enbl_actn_idx ON workflow_case_fsm (parent_enabled_action_id); CREATE INDEX wf_case_fsm_state_idx ON workflow_case_fsm (current_state); CREATE TRIGGER RI_ConstraintTrigger_c_343249 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343250 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343254 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343255 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343259 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343260 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 131,072 bytes -- Table rows: 3,608
Begin main content
