Houstons Neighborhoods

How to model a hierarchy on a relational database?

Hi, This is a tough one. I need to know the table structure on how to do this. I don't want a two level or three level hierarchy. It should be like a file structure where I can go as deep as I want. Any ideas would be much apreciated as well.

Public Comments

1. put a parent id within the table that way the row can relate to another row in the table. From this any row can have a null parent id, or have a parent id that refers to the id of the record that is above the current record.