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.