On Wed, 2007-04-04 at 16:47 -0700, TaMeR wrote: > I have done something like this before with php & mysql creating all > my own sql statements but I am getting a bit confused with the > ForeignKey and ManytoMany fields. > I like to create following models: > > Organizations: May be the users Company or one of many clients > > People: May be a users info or one of many contact person for one > Organization. > > Address: May be People or Organizations > > Phone# Can be Phone, FAX, Mobile etc. for either People or > Organizations > > Where do I place my ForeignKey and ManyToMany fields? > Also, lets take Organization as example: where do I place the select > box which indicates if it is owned by user, a client or a vendor etc.
One approach: - People has a ForeignKey(Address) -- assuming only 1 address per person, otherwise use ManyToManyField. - Organization has a ForeignKey(Address) - Both People and Organization have ManyToManyField(Phone#) - Phone number field contains a field to describe what type of phone number it is (landline, fax, mobile, ...) The People to Organization link can be done through an intermediate table, as in [1]. This allows you to put an attribute on the intermediate table indicating the type of relationship (owner, customer, etc). [1] http://www.djangoproject.com/documentation/models/m2m_intermediary/ 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 -~----------~----~----~----~------~----~------~--~---