How to set username as ForeignKey in Django module. is bellow method is correct?
user = models.ForeignKey(User, db_column="user")
i cannot use ID as ForeignKey because my old db have username as ForeignKey.(I need to migrate the the old Data)
Asked
Active
Viewed 1,673 times
3
Kombuwa
- 1,613
- 4
- 20
- 35
-
maybe this link can help... https://stackoverflow.com/questions/3641483/django-user-model-and-custom-primary-key-field – flakavir Jun 17 '19 at 08:29
-
That's documented: https://docs.djangoproject.com/en/2.2/ref/models/fields/#django.db.models.ForeignKey.to_field – bruno desthuilliers Jun 17 '19 at 08:43
-
And you should really migrate your schema and data indeed, at least if you value your data... – bruno desthuilliers Jun 17 '19 at 08:46
-
@brunodesthuilliers is this correct user = models.ForeignKey(User, on_delete=models.CASCADE, to_field="username") – Kombuwa Jun 17 '19 at 09:23
-
@Kombuwa did you try it ? – bruno desthuilliers Jun 17 '19 at 10:33
1 Answers
2
Use below code:
user = models.ForeignKey(User, to_field="username")
The field on the related object that the relation is to. By default, Django uses the primary key of the related object. If you reference a different field, that field must have unique=True.
Milad Hatami
- 1,494
- 13
- 18