Hi, I’m trying to include an inherited field from an inherited class in the subclass’ compound index. E.g.: from django.db import models # Create your models here. class Base(models.Model): name = models.CharField(max_length=20, db_index=True) class Child(Base): age = models.IntegerField(…

By not specifying abstract=True in the Meta class within the base class, you’re using multi-table inheritance. That means that Base and Child are two separate database tables, each with their own columns and indexes. See Models | Django documentation | Django for more information.

Compound index for inherited field

Using Django

mc613 January 13, 2022, 10:16pm 3

Thanks @KenWhitesell I included the code in the original posting. I’m using Django 3.1.5.

Topic		Replies	Views
Need suggestions for building many models with the same fields approximately Getting Started	8	973	January 6, 2023
unknown field in order clause when using model inheritance Using Django	1	964	November 9, 2021
Question about db_index=False and composite indices Using the ORM	10	1946	August 9, 2022
Abstract models as mixins? Using the ORM	2	88	May 8, 2025
Does model inheritance require field to be named {model_name}_ptr? Using Django	2	1445	October 12, 2021

Compound index for inherited field

Related topics