### As a part of this PR, the following was completed:

- Added Indexes for the `parent_application_id` and
`preceding_application_id` columns.