Great thank about this! On Friday, September 12, 2008 5:38:50 AM UTC+8, Karen Tracey wrote: > > On Thu, Sep 11, 2008 at 5:20 PM, Chris Stromberger > <chris.st...@gmail.com<javascript:> > > wrote: > >> Oh, thanks. Ok, I just tried taking that out (so model now says >> "staff_id = models.ForeignKey(User)"), but that gave this error: >> >> OperationalError: (1054, "Unknown column 'restaurant.staff_id_id' in >> 'field list'") >> >> ? >> > > Try: > > staff = models.ForeignKey(User) > > Django automatically adds _id to the database field name for ForeignKeys > unless you specify db_column, as described in the paragraph that begins > "Behind the scenes" below here: > > http://docs.djangoproject.com/en/dev/ref/models/fields/#foreignkey > > So if your field is actually named 'staff_id' either declare it as 'staff' > and do not specify db_column or declare it as whatever you want and specify > db_column = 'staff_id'. > > Karen > > >> >> On Thu, Sep 11, 2008 at 4:09 PM, Malcolm Tredinnick < >> mal...@pointy-stick.com <javascript:>> wrote: >> >>> >>> >>> On Thu, 2008-09-11 at 16:01 -0500, Chris Stromberger wrote: >>> > I would like to include a foreign key in a table that links to a user >>> > in Django's auth_user table. Or maybe this is a dumb idea--if so, >>> > interested in hearing why. >>> > >>> > >>> > So the table ("restaurant") with the foreign key includes (mysql): >>> > >>> > >>> > staff_id int(11) NOT NULL, >>> > foreign key(staff_id) references auth_user(id) on delete no action on >>> > update cascade, >>> > >>> > >>> > >>> > If I include this in my model: >>> > >>> > >>> > >>> > from django.contrib.auth.models import User >>> > >>> > staff_id = models.ForeignKey(User, db_column = 'id') >>> >>> This probably isn't what you inteded to write. The db_column attribute >>> specifies what the name of the database column in *this* table will be >>> called. The name of the column in the table it refers to is worked out >>> automatically (since it's almost always the primary key of that table >>> and for other cases, Django has the to_field attribute). >>> >>> Regards, >>> Malcolm >>> >>> > >>> >>> >>> >>> >> >> >> >
-- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/DBoV_Kto4H0J. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
