In Django, how do you make a model refer to itself?

django django-models django-orm
user469652 picture user469652 · Feb 6, 2011 · Viewed 22.2k times · Source

Assume we have class Employee. I want to have a field which references a different instance of the same class.

How to write this? How about the following code?

ref_employee= models.ForeignKey('self',null=True,blank=True)

Answer

Jonny Buchanan picture Jonny Buchanan · Feb 6, 2011

http://docs.djangoproject.com/en/dev/ref/models/fields/#foreignkey

To create a recursive relationship -- an object that has a many-to-one relationship with itself -- use models.ForeignKey('self').

So you have it right. It's usually faster to determine if code will do what you want by running it :)

Related questions

Django values_list vs values

In Django, what's the difference between the following two: Article.objects.values_list('comment_id', flat=True).distinct() vs Article.objects.values('comment_id').distinct() My goal is to get a list of unique comment ids under each Article. I've …

Read More
What's the difference between select_related and prefetch_related in Django ORM?

In Django doc, select_related() "follows" foreign-key relationships, selecting additional related-object data when it executes its query. prefetch_related() does a separate lookup for each relationship, and does the "joining" in Python. What does it mean by "doing the joining …

Read More
Django database query: How to get object by id?

Django automatically creates an id field as primary key. Now I need to get the object by this id. object = Class.objects.filter() How to write this filter?

Read More