My application has two node types: a parent node which can hold recursive child nodes. Think of it like the post-comment system in SO, but comments can be recursive:
parent_1
child_11
child_12
child_121
child_13
parent_2
child_21
child_211
child_2111
Important to note that the parent nodes have different attributes and behavior than the child nodes.
Barring recursion I would have the following models:
class Parent(models.Model):
# fields ...
class Child(models.Model):
parent = models.ForeignKey(Parent)
# other fields ...
But the recursion complicates this. What is the correct (and presumably most efficient) way of modeling this relationship in Django?