you don’t need to alter anything to indicate unavailable, just make sure you don’t have an overlap when looking for the desired range
there are several threads in this forum that go into this topic – check out the sql in Checking a number from a range, contained within a range under SQL - #4 by r937
run the query to find overlaps, and if it comes up empty, then your applicatyion logic can go ahead and book the desired range