Adapt storage to actually write the visit_type in the origin_visit_status topic

origin_visit_status_add endpoint should join information out of the origin_visit table. This then sends the complete OriginVisitStatus object to the topic.

Maybe check the replayer is not impacted as well. It should not with swh-vault#1964 (closed) - [1].

• [1] The integration test for the backfiller uses a replayer so this check should go hand in hand already.

---

Migrated from T2965 (view on Phabricator)