Preventing django from appending “_id” to a foreign key field
Each Answer to this Q is separated by one/two green lines.
In django, if I set a field in a model to a foreign key, "_id"
is appended to the name of that field. How can this be prevented?
You can set the field’s db_column
attribute to whatever you’d like.
When using the foreign field in a model, Django creates two fields: One for the actual link, and one that references the other model.
class A(Model):
i = IntegerField()
class B(Model):
a = ForeignKey(A)
In B
there is now two fields: a
and a_id
. a_id
is the unique id as stored in the database, while a
can be used to directly access the fields in A
, like this:
b = B.objects.get(...)
b.a.i = 5; # Set the field of A
b.a.save() # Save A
The answers/resolutions are collected from stackoverflow, are licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0 .