... until the collector arrives ...
I created an SQL script that demonstrates the 'interval' approach to managing hierarchies in SQL. It is based upon approaches presented in Trees in SQL and Nested Intervals with Farey Fractions