Hi Sanjay. unfortunately Django doesn't support composite primary keys. what I do in these case is put a auto-incremented key on orderItems and make a unique index on orderID, item#, and that seems to work ok (for me)
regards Ian On 13/06/2006, at 8:00 PM, Sanjay wrote: > > Hi All, > > Being new to Django, I am curious to know whether Django supports > composite primary keys. For example, can I have a schema like this: > > Table Order ( > OrderID int PK, > OrderDate > . > . > . > ) > > Table OrderItems ( > OrderID int PK, > ItemNo int PK, > Description, > . > . > . > ) > > Table OrderItemDeliveryDates > ( > OrderID int PK, > ItemNo int PK, > DeliveryDate Date PK, > Quantity Required > . > . > . > ) > > Thanks, > Sanjay > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
