There are, of course, many very large databases that would need something like this. However, I've found that most small sites I've worked on, a simple "lineage

There are, of course, many very large databases that would need something like this. However, I've found that most small sites I've worked on, a simple "lineage" system in a completely flat single table is more than adequate. (The following is a link to my own website where I explain it using a Codeigniter library I built. It can be done in any type of code, however) http://codebyjeff.com/blog/2012/10/nested-data-with-mahana-hierarchy-library http://codebyjeff.com/blog/2012/10/nested-data-with-mahana-h...