We already have a flag deleted
in segments. When we delete a segment, it should actually keep the segment entry instead of deleting it fully. This allows us to better delete orphaned segments from archives etc. We should also updated the ts_last_edit
in the segment table and set it to now()
when soft deleting the segment.