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 post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
