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 .