• Collapse the structure to a single table and use a HIERARCHYID.

    That way you can define a flexible heirarchy in this table and attach to specific points.