8

I want a foreign key relation in my model with the username field in the User table(that stores the user created with django.contrib.auth.forms.UserCreationForm).

This how my model looks:

class Blog(models.Model):
    username = models.CharField(max_length=200) // this should be a foreign key
    blog_title = models.CharField(max_length=200)
    blog_content = models.TextField()

The username field should be the foreign key.The Foreign Key should be with this field

bakkal
  • 54,350
  • 12
  • 131
  • 107
Anish Silwal
  • 186
  • 1
  • 1
  • 10

2 Answers2

21

Unless I'm missing something, you can have a ForeignKey to a specific field:

class Blog(models.Model):
    username = models.ForeignKey(User, to_field='username')

https://docs.djangoproject.com/en/1.11/ref/models/fields/#django.db.models.ForeignKey.to_field

jthewriter
  • 333
  • 2
  • 5
  • ... except the field in "to_field" has to be unique in the table. So it doesn't work in general. – C S Apr 18 '18 at 15:45
  • 4
    @CS How does the uniqueness constraint "doesn't work in general"? Take note that the question is on "ForeignKey to a Model field" and as we know, it really has to be unique because that is what a ForeignKey is, a "many-to-one relationship", meaning "many" records from the Blog table relate to "one" record from the User table. If the relating-field (username) is not unique and say there are 3 records with the same value (e.g. John123), then it would not be possible to relate a Blog to User as there are more than 1 record from User with the same field value (for username) to choose from. – Niel Godfrey Pablo Ponciano Apr 07 '21 at 08:50
  • @nponcian you are explaining my point more verbosely than I did, so thanks for that. Hopefully it will clarify things for other readers. – C S Apr 07 '21 at 15:32
12

You can't have an ForeignKey to a field, but you can to a row.

You want username which is available through the User model

So:

blog.user.username

If you insist on having blog.username you can define a property like this:

from django.db import models
from django.contrib.auth.models import User

class Blog(models.Model):
    user = models.ForeignKey(User)

Then to access the field you want use:

blog.user.username

If you insist on having blog.username you can define a property like this:

from django.db import models
from django.contrib.auth.models import User

class Blog(models.Model):
    user = models.ForeignKey(User)

    @property
    def username(self):
        return self.user.username

With that property, you can access username through blog.username.

Note on how to import User

user = ForeignKey('auth.User')

or

from django.contrib.auth.models import User
user = ForeignKey(User)

or the more recommended

from django.conf import settings
user = ForeignKey(settings.AUTH_USER_MODEL)
bakkal
  • 54,350
  • 12
  • 131
  • 107