id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
33821	Use _fk as suffix for augmented related model value fields	Anton Agestam	nobody	"Django uses _id as suffix [1] for accessing the underlying related value for relationship fields (ForeignKey et al). This is cause for a lot of confusion when used in conjunction with `to_field`, that is when having a relation to a non-primary key field. It's also confusing if the primary key field of the related model isn't named `id`.

[1]: https://docs.djangoproject.com/en/4.0/ref/models/fields/#database-representation

To make this situation better, I propose replacing the _id suffix with _fk instead, which makes it more obvious that this value is a sort of proxy to a value on the related model. Of course this change couldn't be made without a proper deprecation cycle, so the _id suffix should work in parallel with the new _fk field for a sufficient length of time to be phased out."	Cleanup/optimization	closed	Database layer (models, ORM)	4.0	Normal	wontfix			Unreviewed	0	0	0	0	0	0