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
13822	ForeignKey's attname is counter-intuitive when referencing to a field not named 'id'	Alexander Schepanovski	Alexander Schepanovski	"{{{
class SomeModel(model.Model):
    region = models.ForeignKey(Region, to_field='code')

sm = SomeModel()
sm.region # works
sm.region_code # AttributeError, currently
sm.region_id # works, but evaluates to sm.region.code
}}}

Also, currently we have:
{{{
CREATE TABLE ""app_somemodel"" (
    ...
    ""region_id"" integer NOT NULL REFERENCES ""geo_region"" (""code"") DEFERRABLE INITIALLY DEFERRED,
    ...
);
}}}
which also looks strange."	Bug	closed	Database layer (models, ORM)	1.2	Normal	wontfix	db, ForeignKey		Design decision needed	1	0	0	0	0	0