SQL Hierarchy – Hierarchies are a problem in SQL – An SQL smell
Illustration showing single table self-referencing hierarchy in front of a diary page. Hierarchies present are one of several SQL Smells or Requirements Smells. They are difficult to understand, communicate and specify.