Tracks processes associated with a Request Handler request.

Definition:

     Column      |       Type        | Collation | Nullable | Default

-----------------+-------------------+-----------+----------+---------

 process_id      | numeric           |           | not null |

 state           | character varying |           | not null |

 command_id      | numeric           |           | not null |

 job_id          | character varying |           |          |

 delivery_method | character varying |           |          |

 arguments       | character varying |           |          |

 file_id         | numeric           |           |          |

 request_id      | numeric           |           |          |

 data_entity_id  | numeric           |           |          |

 process_type    | character varying |           | not null |

Indexes:

    "rh_processes_pkey" PRIMARY KEY, btree (process_id)

Check constraints:

    "rh_processes_check" CHECK (request_id IS NOT NULL AND data_entity_id IS NULL OR request_id IS NULL AND data_entity_id IS NOT NULL)

Foreign-key constraints:

    "fk_rh_proce_rh_proces_rh_reque" FOREIGN KEY (request_id) REFERENCES rh_requests(request_id)

    "rh_processes_command_id_fkey" FOREIGN KEY (command_id) REFERENCES rh_commands(command_id)

    "rh_processes_data_entity_id_fkey" FOREIGN KEY (data_entity_id) REFERENCES rh_data_entities(data_entity_id)

    "rh_processes_file_id_fkey" FOREIGN KEY (file_id) REFERENCES rh_files(file_id)

Columns:

process_id: primary key

state: always QUEUED

command_id: foreign key into rh_commands

job_id: ? not populated

delivery_method: ? not populated

arguments: arguments to script being executed in this process? not populated

file_id: meant to be foreign key into rh_files? not populated

request_id: foreign key into rh_requests

data_entity_id: obviously intended to be data entity to which file(s) associated with this process belong; foreign key into rh_data_entities; however, not populated

process_type: always RequestProcess