[eluser]tomdelonge[/eluser]
For some reason, I honestly can't get my head around "self relationships". I looked at the bug model in the example application, along with the model in the advanced relationships section of the DMZ userguide.
I imagine that each category "has one" parent and "has many" children. I honestly don't know what to setup for a table and how I would setup a query to find each category and it's children.
I don't understand what to put for "other_field" and such. Quite frankly, I don't really know how to even start with this.
Any tips? (Like I said, I looked over the user guide, I just can't figure this out)