Postgresql supports storing range of values, in particular ranges of timestamps. I never used them but the manual page shows an example on avoiding overlaps th

Postgresql supports storing range of values, in particular ranges of timestamps. I never used them but the manual page shows an example on avoiding overlaps that looks a lot like your case: https://www.postgresql.org/docs/12/rangetypes.html#RANGETYPES-CONSTRAINT https://www.postgresql.org/docs/12/rangetypes.html#RANGETYPE...