On: Subcases and Hierarchy

This is the first time I've run across trees/nodes in the organization of relational data. Makes a lot of sense and certainly sounds like someone was "thinking outside the box".

The nested set model is a well-known workaround for storing tree-like structures in a relational database.