Composite primary key in django

by

Try similar below code:

class MyTable(models.Model):
    class Meta:
        unique_together = (('key1', 'key2'),)

    key1 = models.IntegerField(primary_key=True)
    key2 = models.IntegerField()

or if you want only unique mixed fields:

class MyTable(models.Model):
    class Meta:
        unique_together = (('key1', 'key2'),)

    key1 = models.IntegerField()
    key2 = models.IntegerField()

EDIT: I would like to note that there is a problem with this approach if there are 3 columns. Update queries don’t work because it tries to update (puts pk fields right after “SET”) the fields that are unique together and obviously fails.

More Related Contents:

  1. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  2. Django JSONField inside ArrayField
  3. django.db.utils.OperationalError Could not connect to server
  4. Use Django ORM as standalone [duplicate]
  5. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  6. Django connection to postgres by docker-compose
  7. How to set up a PostgreSQL database in Django
  8. How do you join two tables on a foreign key field using django ORM?
  9. Case insensitive unique model fields in Django?
  10. Django JSONField filtering
  11. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  12. How to find pg_config path
  13. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  14. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  15. What is the default order of a list returned from a Django filter call?
  16. Deploying Django to Heroku (Psycopg2 Error)
  17. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  18. How to perform filtering with a Django JSONField?
  19. Iterate over model instance field names and values in template
  20. Using Django time/date widgets in custom form
  21. Best practices for adding .gitignore file for Python projects? [closed]
  22. How do I get the object if it exists, or None if it does not exist in Django?
  23. Find object in list that has attribute equal to some value (that meets any condition)
  24. Psycopg2 image not found
  25. Change Django ModelChoiceField to show users’ full names rather than usernames
  26. django-debug-toolbar not showing up
  27. gunicorn.errors.HaltServer: django
  28. Django Admin Page missing CSS
  29. How can I set two primary key fields for my models in Django?
  30. Can I make STATICFILES_DIR same as STATIC_ROOT in Django 1.3?

Leave a Comment