[Django]-Django suffix ForeignKey field with _id

by

37👍

✅

Well it turns out there’s a keyword argument called db_column. If you want the field named ‘f’ in the database table, it’s just as simple as:

f = models.ForeignKey(AnotherModel, db_column='f')

Further reference:

The name of the database column to use for
this field. If this isn’t given, Django will use the field’s name.

If your database column name is an SQL reserved word, or contains
characters that aren’t allowed in Python variable names — notably,
the hyphen — that’s OK. Django quotes column and table names behind
the scenes.

https://docs.djangoproject.com/en/2.2/ref/models/fields/#db-column

👤S. Liu

Leave a comment